Year: 2010

How to manually synchronize replication subscriptions by using backup or restore

Chris Skorlinski [MSFT] Inside Replication April 12, 2010

The Microsoft Knowledge Base contains the following article for setting up a SQL 2000 Subscriber using Backup/Restore. Once the subscriber is restored sp_scriptpublicationcustomprocs is executed to create the subscriber Replication SPs. 320499 How to manually synchronize replication subscriptions by using backup or restore http://support.microsoft.com/default.aspx?scid=kb;EN-US;320499 These steps should be modified for SQL 2005/2008 which automatically creates
Read More »

Troubleshooting LogReader Error “repldone log scan occurs before the current start of replication”

Chris Skorlinski [MSFT] Troubleshooting April 11, 2010

Below are cause and recommendation for the SQL Replication LogReader error “The specified LSN (…) for repldone log scan occurs before the current start of replication in the log (…).’. When the LogReader starts, it verifies the Last Distributed transaction (last transaction in msrepl_transactions) still exists in the transaction log. This confirms the Published database
Read More »

Distribution Agent Fails with error Msg 0, Level 20, State 0, Line 0

ReplTalk Troubleshooting April 5, 2010

Any Cox | Microsoft Premier Field Engineer We recently encounter the a problem where Replication Distribution Agent failed with error below while trying to replicate the “execution” of a stored procedure. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Executing
Read More »

Merge Agent blocked by sp_mergemetadataretentioncleanup

Chris Skorlinski [MSFT] Troubleshooting April 5, 2010

Problem Customer observes high latency in SQL Server 2005 Merge replication. In sysprocesses you see that Merge agents are being blocked by another Merge agent & the blocker Merge agent SPID is sleeping with “AWAITING COMMAND”. Root Cause If you take output of “select open_transaction_count from sys.dm_exec_requests where session_id = <blocker SPID>” & find that
Read More »

How SQL Server 2005/2008 Replication resumes interrupted snapshot delivery

ReplTalk Inside Replication April 5, 2010

Anurag Sharma | Microsoft SQL Server Escalation Services Background In many cases customer often have large databases published and creating a snapshot of such large database is always a pain. And, even when published databases are of manageable size, a slow or unreliable network link can further complicate the issue. From SQL Server 2005 onwards
Read More »