ALTER DATABASE

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