Share this PostSateesh Yele Microsoft SQL Server Escalation Services. Issue:The distribution agent is failing when applying the snapshot so it will retry applying the snapshot again and again. Below is the Distribution agent verbose log that explains the error message and you can see that the distribution agent is retrying the snapshot by scanning the
Read More »
Share this PostReplicate Execution of Stored Procedure and CDC: With Transactional Replication you can replicatethe execution of the Stored Procedure like this: This has several advantages as discussed in this article: http://msdn.microsoft.com/en-us/library/ms152754.aspx . When you enable Change Data Capture (CDC) at the Database level, replication of the stored procedure execution will NOT work. This is
Read More »
Share this PostWe encountered an unusual timing problem while pushing a Snapshot down to a merge subscriber. We don’t expect many to encounter this problem, after all we’ve only seen it once in 15 years. We wanted to share this as a learning opportunity as it illustrates a classic application\thread synchronization problem. Scenario Customer has
Read More »
Share this PostIn the middle of a huge phased migration from SQL 2000 to SQL 2008 we noticed the SQL 2008 publisher\distributor was causing blocking when replicating data changes to the SQL 2000 subscriber. We discovered the SQL Server 2005\2008\2012 Distribution Agent was configured to replicate as native SQL commands instead of default parameterized stored
Read More »
Share this PostThis is a follow up post to my article Using “Verbose history agent profile.” while troubleshooting Replication. Using SQL Server Management Studio you can set a default profile for all Replication Agents. In this walk through I’ll change ALL Merge Agents default to use the “Verbose History Agent Profile”. In SSMS, right click
Read More »