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


Stopping a database server in a mirroring system

Before performing maintenance on a database server in a high availability system, stop the database server.


You must use a connection to the utility database to stop the server, so it is recommended that you include the -su server option when you started the database server.

Context and remarks


 Stop a primary, mirror, or arbiter server using the Stop Database utility (dbstop)
  • Issue a dbstop command to stop the database server.

    For example, the following command stops a database server named mirror_server1:

    dbstop -c "UID=DBA;PWD=sql;DBN=utility_db;LINKS=tcpip" mirror_server1


The database server stops. Provided that at least two servers in the high availability system remain, users should be able to connect to either a copy of the database. But, depending upon which server is stopped, users may or may not be able to update the database.


When you stop a primary, mirror, or arbiter server, your system continues to operate; however, to maintain high availability, you need to restart or replace the stopped database server.

 See also