Microsoft® SQL Server 2012 Unleashed

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