Troubleshooting Replication Failures
Configuring replication and monitoring for successful replication is relatively easy. The fun begins when failures start arising. Replication Monitor pays for itself quickly. Red flags begin appearing to indicate agent failures. Depending on how you have the alerts defined, you probably also get numerous emails or pages.
The following are the most common issues you find with data replication:
• Data row count inconsistencies, as discussed in the preceding section
• Subscriber/publisher schema change failures
• Connection failures
• Agent failures
For the conventional replication situations, if the problem is with the validation of subscriptions processing, it is usually best to resynchronize the subscription ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
