Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » SQL Anywhere high availability » Database mirroring system setup

 

Forcing a database server to become the primary server

In situations where you need to force the primary server to shut down (for example, if you are replacing the computer it is running on), you can force the mirror server to become the primary server when it would not otherwise take ownership of the database by using the ALTER DATABASE statement.

You must connect to the utility database on the mirror database server to use this feature. To connect to the utility database, you must specify the -su option in the command to start the mirroring servers. The following command forces the mirror server for the database mymirroreddb.db to become the primary server:

ALTER DATABASE mymirroreddb FORCE START;

The FORCE START clause forces a database server that is currently acting as the mirror server to take ownership of the database. This statement must be executed while connected to the utility database on the mirror server. See Utility database connections.

If you want to force a failover from the primary server to the mirror server, you can:

 See also