Specify if an existing database should begin using synchronous or asynchronous replication.

Syntax

ALTER DATABASE db_name { SET | WITH } { SYNC | ASYNC } REPLICATION;

Remarks

• db_name is the name of the existing database for which you want to specify the replication setting.

Example

The following example specifies that the database test_db should begin using synchronous replication.

ALTER DATABASE test_db SET SYNC REPLICATION;

Related Topics

• CREATE DATABASE

Was this Article Helpful?

Thanks For Your Feedback!