1) MaxBCPThreads (contributed by Sanjaya Padhi, Microsoft SQL Server Support) I found we can add in the below point to increase the perf of the snapshot application by the distribution agent by use of MaxBCPThreads parameter as mentioned in the article below. Please note this does not apply when Snapshot created using default “concurrent” option.
Read More »
Satesh Yele | Microsoft SQL Server Support Quick collection of links for getting started with Transactional Replication. Transactional Replication http://msdn.microsoft.com/en-us/library/ms165720(SQL.90).aspx How Transactional Replication Works http://msdn.microsoft.com/en-us/library/ms151706(SQL.90).aspx Considerations for Transactional Replication http://msdn.microsoft.com/en-us/library/ms151254(SQL.90).aspx Replication Security Best Practices http://msdn.microsoft.com/en-us/library/ms151227(SQL.90).aspx Implementing Replication http://msdn.microsoft.com/en-us/library/ms151847(SQL.90).aspx SQL Server Replication (How Do I) http://msdn.microsoft.com/en-us/library/ms166348(SQL.90).aspx Configuring Distribution http://msdn.microsoft.com/en-us/library/ms151860(SQL.90).aspx How to: Configure Distribution (SQL Server Management
Read More »
LogReader fails with error 15517: 2010-02-25 21:16:35.054 Status: 0, code: 20011, text: 'The process could not execute 'sp_replcmds' on 'CHRISSKACER'.'. 2010-02-25 21:16:35.056 The process could not execute 'sp_replcmds' on 'CHRISSKACER'. 2010-02-25 21:16:35.057 Status: 0, code: 15517, text: 'Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot
Read More »
Balakrishnan Shankar | Microsoft SQL Server Escalation Services During the course of troubleshooting, Microsoft SQL Support team we collect from customers the Publication Creation Script. In cases involving Snapshot generation and application problems, it might become necessary to decrypt the schema options for an article from customer’s script. Below script will help deduce that. The
Read More »
I’m posting a collection of SQL Server 2008 Merge Replication Best Practices. The material below includes text from SQL Books Online, other white papers, KB articles, web postings, and little from experience I gained working with SQL Replication for almost 15 years. The “best practices” below are in no particular order. My objective was to
Read More »