Category: Troubleshooting

Troubleshooting Error: The merge process was unable to perform data validation on article

Share this PostSateesh Yele | Microsoft SQL Server Support I would like to share information about an interesting Replication issue I recently worked. Customer was getting unusual error messages during synchronization. Symptom: Merge agent is failing with the following error message when validating large tables with checksum. The merge process was unable to perform data
Read More »

Divide and Conquer Transactional Replication using Tracer Tokens

Share this PostAs we know, Transactional Replication moves data from the Publisher to the Distributor then to the Subscribers.  When working, data flows near real-time through both of these steps.  When problems occur which interrupt this flow, latency is introduced.  The challenge is to find which step is contributing to the overall latency.  Tracer Tokens
Read More »