Check status and operation

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

StepsTo check the status and operation of the Replication Server

  1. Log in to the Replication Server with a user login that has “sa” permission.

  2. 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.

  3. 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.

    NoteYou 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.