Test that the database mirroring system is running properly by reviewing database and database server properties.
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.
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
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|