Category: Troubleshooting

Tips to improve performance when applying Snapshot in Transactional Replication

Share this Post1) 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
Read More »

LogReader fails with Cannot execute as the database principal because the principal “dbo” does not exist

Share this Post LogReader fails with error 15517: [crayon-5d303524b49ba581185168/] The SQL Agent was configured to run using ‘ChrisSkAcer\Chris’.  In login properties, this account has “system administrator” rights.  To eliminate JOB properties or SQL Agent authentication  as problem, tried running LogRead.exe from CMD prompt while logged on using the same administrator count. c>logread.exe –Publisher [CHRISSKACER] –PublisherDB
Read More »

Reinitialization MS SQL Replication Subscirber may cause data loss

Share this PostIn Transactional Replication Subscriber reinitialization instructs the Distribution Agent to locate and distribute a NEW Snapshot to the Subscriber.  In Merge Replication, the reinitialization is done by the Merge Agent. Depending on the Replication settings, the Subscriber tables may either be 1) dropped, deleted, or 3) truncated resulting in loss of data on
Read More »

Transactional Replication Conversations

Share this Post Transactional Replication Conversations When troubleshooting Transactional Replication performance break down the flow of data into 4 simultaneous conversation.  Examine performance of each conversation.  This will help verify where the bottleneck investigation should begin. 1)      LogReader Reader thread is reading the Transaction Log via stored procedure sp_replcmds, a wrapper for xp_replcmds.  It scans
Read More »

Using Windows Synchronization Manager on x64 to Synchronize Replication

Share this PostWindows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version.  The x64
Read More »