Holger Linke Microsoft SQL Server Escalation Services Abstract: This article describes an issue with SQL Server Transactional Replication that was detected recently. If you have configured the Log Reader agent to use the MaxCmdsInTran parameter, and also have configured the Distribution database to use the “sync with backup” option, you may experience a failure of
Read More »
Holger Linke Microsoft SQL Server Escalation Services Abstract Provides details and explanations why SQL Server Merge Replication does not support central subscriber topologies. This fact was originally stated in SQL Server Books Online and further documented in KB article KB 2750005, but is still causing some misconceptions and confusion. This blog article will provide additional
Read More »
Sateesh 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 first LSN
Read More »
Replicate 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 By Design.
Read More »
Jose Moreira B. Neto Microsoft SQL Server Escalation Services From SQL Server BOL we have: -ReadBatchSize Is the maximum number of transactions read out of the transaction log of the publishing database per processing cycle, with a default of 500. -MaxCmdsInTran Specifies the maximum number of statements grouped into a transaction as the Log Reader
Read More »