Microsoft Blog Images
Browse by Tags
Search this blog
Search all blogs
Email Blog Author
RSS for posts
RSS for comments
Tagged Content List
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...
14 Mar 2012
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...
29 Nov 2011
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...
6 Oct 2011
-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. ...
7 Aug 2011
Page 1 of 1 (4 items)
© 2013 Microsoft Corporation.
Privacy & Cookies