Re-configure Replication after restoring publication database from Backup – Replication Scenario

Sharing one of the interesting scenario I worked today. Somebody messed up the data at publication database (few rows updated with a value which they aren’t supposed to) and publication database was restored from a older backup to rollback the change. Now when log reader agent was started it starting failing with an error: 2012-03-14 01:08:14.360…

2

Snapshot replication fails after adding a column to a table (article)

This post is all about “replicate_dll” property in sp_addpublication, so if you are aware of this property then this is the answer for the problem described in the blog title. Here is a little more background about this issue: A column was added to an existing table using the query below: ALTER TABLE [db].[tblUsers] ADD [BloodGroup]…

2

How to troubleshoot – "Incorrect syntax near – Source: MSSQLServer, Error number: 102)" errors in replication

A quick guide on how to troubleshoot Incorrect syntax near – Source: MSSQLServer, Error number: 102)” errors in replication Firstly, check for any known issues like http://support.microsoft.com/kb/935563 by searching with the error message in bing If there is no known issue, run a profiler by connecting to the subscriber because these errors are reported while applying…

0

-MaxBCPThread parameter for Snapshot and Distribution Agent in SQL Server Replication

If you have researched about replication enhancement, for sure you would have heard about this Parameter which is applicable for both snapshot agent and distribution agent. I’m going to share some useful information regarding this parameter which you can leverage in your replication environment. What is MaxBCPThread all about? When used with the Snapshot Agent, …

3