I’m developing in-depth training on Change Data Capture and created this BLOG posting as a reference for BOL topics and Web links I found helpful while researching CDC. I’ll update this posting with more links as time goes by. I hope you too find these helpful. Basics of Change Data Capture (great chart and overview
Read More »
Error messages: Unable to decide if MakeGeneration is needed. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199360) Get help: http://help/MSSQL_REPL-2147199360 Query timeout expired (Source: MSSQLServer, Error number: 0) Get help: http://help/0 The merge process failed to execute a query because the query timed out. If this failure continues, increase the query timeout for the process. When troubleshooting, restart
Read More »
New for SQL 2008 is the ability for the Distribution Agent to push updates to the Subscriber using multiple connections. This feature, called Subscription Streams, only works when replicating transactions as stored procedures and not TSQL statements. See: Enhancing Transactional Replication Performance (Use the –SubscriptionStreams parameter for the Distribution Agent.) Background The published articles can
Read More »
From time to time we need to restore a customer’s Distribution database to a secondary server or to a lab server for testing. When you restore a distribution database it will not be configured to execute Replication commands such as sp_browsereplcmds. However, there is a simple solution. You can execute the command below to configure
Read More »
Sateesh Yele | Microsoft SQL Server Support Below is a list of self-help resources or this scenario. These resources are used by Microsoft SQL Replication Support Engineers during an Advisory Services engagement or while troubleshooting Web Synchronization problems. We hope you too find these helpful. Web Synchronization for Merge Replication http://msdn.microsoft.com/en-us/library/ms151763.aspx Topologies for
Read More »