You are viewing an older version of this section. View current production version.

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