ReplTalk
All about Microsoft SQL Replication

Category: Inside Replication

ReplTip – Setting LogScanThreshold can result in LogReader failure

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting September 21, 2015

Share this PostContent provided by Sateesh Yele, Microsoft SQL Escalation Services BOL/MSDN documents –Logscanthreshold as “internal use only”. https://technet.microsoft.com/en-us/library/ms146878(v=sql.110).aspx -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”

Chris Skorlinski [MSFT] Inside Replication March 8, 2015

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 »

SQL Server Profiler showing 9003 Exception when CDC is configured

Chris Skorlinski [MSFT] Inside Replication, Troubleshooting July 22, 2014

Share this PostWhile troubleshooting a customers environment I encountered the following 9003 Exception error message captured in SQL Server Profiler. “The log scan number (42:358:1) passed to log scan in database ‘<db name>’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).
Read More »