Checking the Status and Operation of the Replication Server

Replication Server provides several admin commands you can use to check its status and operation.

1. Log in to the Replication Server with a user login that has “sa” permission.
2. Check the current status of the Replication Server:

   admin health

   This command returns the current status of the Replication Server, as shown in this 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.

3. Check the current status of the Replication Server primary database connection (the connection from the Replication Agent to the primary Replication Server):

   admin show_connections

   You can also use the admin who, dsi command to get more information about the Replication Agent connection in the primary Replication Server.

   Note: 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 Replication Agent connection in the primary Replication Server.