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 »

ReplTip – Troubleshooting sp_msmakegeneration

Chris Skorlinski [MSFT] Troubleshooting September 20, 2015

by Holger Linke, Microsoft SQL Escalation Engineer Symptoms: The merge agent may get stuck without apparent progress, or even fail with a timeout error. If several merge agents are trying to synchronize at the same time, they would block each other, until the agent which is running sp_msmakegeneration finishes the call. If the execution of
Read More »

ReplTalk ReplTip – Replication Agent fails with “unable to start correctly”

Chris Skorlinski [MSFT] Troubleshooting March 10, 2015

ReplTalk ReplTip – Replication Agent fails with “unable to start correctly” Taiyeb Zakir Microsoft SQL Server Escalation Services When you have a large number of SQL Server Agent or Replication Agent Jobs running, some of the Jobs may not even start. You might see an error like this in the Event log: “The application was
Read More »

website challenges

ReplTalk ReplTalk Blog December 6, 2023

Sorry, but Repltalk.com website is having a few challenges today and we’re working to get these corrected. There has been a critical error on this website. Chris Skorlinski

Using “Verbose history agent profile.” while troubleshooting Replication

Chris Skorlinski [MSFT] Best Practices, Troubleshooting July 13, 2010

The “default” Agent Profile enables “-HistoryVerboseLevel 1” which provides limited detail in the Distribution database history tracking tables. Using Replication Agent Profile “Verbose history agent profile.” enables “-HistoryVerboseLevel 2” which provides additional diagnostic data while troubleshooting SQL Server Replication. The “Verbose history agent profile.” can be set using Replication Monitor for all types of SQL
Read More »