[5-day-delivery] Troubleshoot SQL Server Replication

Metadata

• 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

Management

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

Deliverable(s)

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

Prerequisite(s)

• Database server access
• Screen sharing, if applicable