Category: Best Practices

Replication: Unable to Synchronize subscribers via Web Synchronization

Share this Postreposting from Claudia Silva Microsoft SQL Escalation Services United Kingdom http://blogs.technet.com/b/claudia_silva/ Problem: The upload message to be sent to Publisher ‘XXX’ is being generated The merge process is using Exchange ID ‘XXXXX’ for this web synchronization session. No data needed to be merged. Request message generated, now making it ready for upload. Upload
Read More »

Very Slow Data Repartitioning in SQL Server Replication with Precomputed Partitions

Share this PostHere is a great posting by Kevin Locke on a problem he encountered when data modifications occurred near the top of a complicated replication filter configuration.  These changes can cause “partition change” which triggers re-evaluation of all child data; also known as “repartitioning”.  Kevin’s solution was to add an index to the Merge
Read More »