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 » Tutorial: Creating a database mirroring system

 

Lesson 4: Stopping your database mirroring system

Stop the mirroring system by stopping the servers in the following order: the mirror server, the primary server, and finally the arbiter server.

Prerequisites

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Creating a database mirroring system.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Creating a database mirroring system with multiple databases that share an arbiter server.

 Task

  1. Stop the database mirroring system by stopping the mirror server, the primary server, and finally the arbiter. Run the following commands in order: 

    dbstop -y -c "UID=DBA;PWD=sql;SERVER=mirror_server2;DBN=utility_db"
    		 
    dbstop -y -c "UID=DBA;PWD=sql;SERVER=mirror_server1;DBN=utility_db"
    		 
    dbstop -y -c "UID=DBA;PWD=sql;SERVER=demo_arbiter;DBN=utility_db"

  2. (Optional) Delete the c:\server1, c:\server2, and c:\arbiter directories.

Results

The mirroring system is stopped.

Next

Proceed to Lesson 5: (Optional) Restarting the mirroring system.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0