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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » SQL Anywhere High Availability » Introduction to database mirroring » Setting up database mirroring

Specifying a preferred database server Next Page

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 using the ALTER DATABASE statement. You must be able to connect to the utility database on the database server to use this feature. You can connect to the utility database by specifying -su option in the command to start the mirroring servers, or by specifying a password in the util_db.ini file. The following command forces the mirror server for the database mymirroreddb.db to become the primary server:


For more information, see ALTER DATABASE statement.

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 database on the primary server, and can be executed from within a procedure or event.