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 2: Testing that the database mirroring system is running properly

Test that the database mirroring system is running properly by reviewing database and database server properties.

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

  • Run the following command, to view:

    • The mirror role of the database serve

    • The name of the database server you are connected to

    • The states of the partner, mirror and arbiter servers

    dbping -c "UID=DBA;PWD=sql;SERVER=mirror_demo_primary" -ps ServerName -pd MirrorRole,MirrorState,PartnerState,ArbiterState

Results

Information about the database properties is returned.

Next

Proceed to Lesson 3: Switching roles in a database mirroring system.

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