Specify all articles when subscribing to a publication using concurrent snapshot processing.

Chris Skorlinski [MSFT] Troubleshooting April 4, 2012

I recently encountered this error when setting up Transactional Replication via SQL scripts. Msg 14100, Level 16, State 1, Procedure sp_MSrepl_addsubscription, Line 533 Specify all articles when subscribing to a publication using concurrent snapshot processing. Looking at my create Publication script I see the default @sync_method = N’concurrent’ being set in sp_addpublication. Nothing I want
Read More »

SQL Replication Agent will RETRY for 4085 Years

Chris Skorlinski [MSFT] ReplTalk Blog August 25, 2010

Have you noticed the SQL Server Agent Job RETRY is set to 2147? Well it is not, the dialog window just cuts off the rest of the digits. Actually the Replication Agent are set by default to retry 2147483647 times, once every minute. That is over 4000 years! 2147483647 = 35791394 Hours = 1491308 Days
Read More »

Divide and Conquer Transactional Replication using Tracer Tokens

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting, Try This March 11, 2010

As 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 help you
Read More »

Repltalk – Replication Tuning Knobs – LogReader

Chris Skorlinski [MSFT] Best Practices October 19, 2016

Chris SkorlinskiMicrosoft SQL Server Escalation Services If you’re familiar with Microsoft SQL Server Replication technology you already know each Replication Agent has various parameters or knobs you can set via Agent Profile or SQL Agent job parameter. This series of posts provide insight into tuning Replication performance using these knobs. Following the 80-20 rule, 80%
Read More »

ReplTip – Breakout by Article

Chris Skorlinski [MSFT] Troubleshooting, Try This September 21, 2015

My friend Brendan Odwyer gave me great query to show Distribution database breakout by article for Transactional Replication publications. We used this to identify 1 table that had +90 million rows pending in the Distribution database as result of a large bulk update. It would have taken Replication days to move that bulk down row-by-row.
Read More »