Replication Server provides several admin commands that you can use to check on its status and operation.
To check the status and operation of the Replication
Server
Log in to the Replication Server with a user login that has “sa” permission.
Use the following command to check the current status of the Replication Server:
admin health
This command returns the current status of the Replication Server, as shown in the following example:
Mode Quiesce Status ------- ------- ------ NORMAL FALSE HEALTHY
If the Replication Server status is SUSPECT
,
use the admin who_is_down command
to check for Replication Server threads that may be down or attempting
to connect to other servers.
Use the following command to check the current status of the Replication Server database connections, including the connection from the Mirror Replication Agent to the Replication Server:
admin show_connections
You can also use the admin who, dsi command to get more information about the Mirror Replication Agent connection in the Replication Server.
You can use the admin show_connections or admin
who, dsi command output to verify that the primary data
server and primary database names are correct for the Mirror Replication Agent connection
in the primary Replication Server.
For more information about the admin show_connections and admin who commands, see the Mirror Replication Agent Reference Manual.