Category: Inside Replication

Inside Distribution Cleanup Watermark

Share this PostThe Distribution database is a cache of undistributed commands that the Distribution SQL Agent jobs are responsible to deliver to their subscribers.  This cache is populated by the Publisher LogReader Agent job as new data changes are detected. The primary tables holding the cache of undistributed data is MSrepl_transactions and MSrepl_commands. Share this
Read More »

Script to decrypt the @schema_option for a Transactional Replication Article

Share this PostThe code below helps decrypt @schema_option settings for Transaction Replication articles. Note the meaning of binary offset may change in future builds of SQL Server. Always check Microsoft docs for most accurate listing. You’ll find scheme_options listing documented at sp_addarticle. Code for this example now posted on Example: [crayon-5cbf8c2c0025d267620651/] Share this Post

ReplTip – Setting LogScanThreshold can result in LogReader failure

Share this PostContent provided by Sateesh Yele, Microsoft SQL Escalation Services BOL/MSDN documents –Logscanthreshold as “internal use only”. -LogScanThreshold scan_threshold Internal use only. Other blog postings imply how to adjust this setting for better Logreader agent performance.  If you add this parameter to the Logreader SQL Agent command line and start the agent, Logreader
Read More »

ReplTip – Subscribe to “all” restriction using “Initialize with backup”

Share this PostReplTip – Subscribe to “all” restriction using “Initialize with backup” Chris Skorlinski Microsoft SQL Server Escalation Services I ran into a couple of challenges using the Backup\Restore method to setup a SQL Server Replication Subscriber.  In particular, using this method you are unable to subscribe or un-subscribe to an individual article.  Using Backup\Restore
Read More »