Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » High availability and read-only scale-out systems » Database mirroring » Maintaining a database mirroring system

 

Stopping a database server in a mirroring system

You may need to stop a database server in a mirroring system to apply a Support Package or minor release, or to remove a server from the mirroring system.

Prerequisites

The database server must have been started using the -su database server option to set the password for the utility database. You must have the password for the utility database.

 Task

  • Run a dbstop command to stop the database server. You must specify the connection parameters for the utility database in the connection string. 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

Results

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

Next

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
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0