[5-day-delivery] Troubleshoot SQL Server Replication


  • Title: [5-day-delivery] Troubleshoot SQL Server Replication
  • Category: 5-day-delivery
  • Tag(s): SQL Server, Troubleshoot, Replication
  • Description: You want to troubleshoot and fix SQL Server replication errors.

Common Issue(s)

  • Errors with the Snapshot Agent
  • Errors with the Log Reader Agent
  • Errors with the Queue Reader Agent
  • Errors with the Distribution Agent
  • Errors with the Merge Agent
  • Troubleshooting Oracle Publishers
  • Troubleshoot error 20598 in transactional replication
  • 20011 error messages in SQL Server when the Replication Log Reader Agent fails


  • Fixed-time: 5 working day(s)
  • Fixed-scope: 1 publication - subscription pair
  • Fixed-price: $500

Work Breakdown

  • Troubleshoot publisher/publication
    • Find errors with the Snapshot Agent
    • Find errors with the Log Reader Agent
    • Find errors with the Queue Reader Agent
  • Troubleshoot subscriber/subscription
    • Find errors with the Distribution Agent
    • Find errors with the Merge Agent
  • Verbose logging
  • Monitoring

Out of Scope

  • Some solutions might require planning for a maintenance window and thus are out-of-scope for this task.


  • The publication - subscription pair should synchronize.
  • Recommendations
    • Database Level
    • Server Level
  • Clarification call (up to 1 hour)


  • Database server access
  • Screen sharing, if applicable