Replication Server Troubleshooting Issues

Use Replication Server commands to check for the most common replication problems.

For more detailed information about diagnosing and solving Replication Server problems, see the Replication Server Troubleshooting Guide.

• Replication Definitions and Subscriptions Check
  Verify that you created replication definitions with the appropriate information and that you have defined and activated subscriptions for all replication definitions.
• Checking the Status and Operation of the Replication Server
  Replication Server provides several admin commands you can use to check its status and operation.
• Verifying that rs_username Login has Appropriate Permissions
  Verify the Replication Agent login in Replication Server.
• Verifying Stable Queues
  Check the Replication Server stable queues to determine which transactions are being processed or ignored, and to determine whether transactions are open (not committed).
• Performance Monitoring
  You can monitor the performance of Replication Server using the rs_ticket and rs_ticket_report Replication Server stored procedures, which respectively reside at the primary and replicate databases. Replication Agent provides support for these stored procedures through the Replication Agent rs_ticket command.