Author: ReplTalk

All about “Not for Replication”

Rishi Maini | Microsoft SQL Server Escalation Services All about “Not for Replication” “Not for Replication” is a property which can be set for different objects like Check constraints, Foreign Key constraints, Triggers , Identity columns etc while using SQL Server Replication. Feature used when the DBA would like the transactions to behave differently when
Read More »

The process could not execute ‘sp_repldone/sp_replcounters’

Anurag Sharma | Microsoft SQL Server Escalation Services Log Reader fails with below error message The process could not execute ‘sp_repldone/sp_replcounters’ on ‘SQLGUY’. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 The log scan number (23:49:3) passed to log scan in database ‘PUBLISHER’ is not valid. This error may indicate data corruption or that the
Read More »

Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Sudharshan Prahallada, Microsoft SQL Replication Support team walks through setting up Peer-2-Peer Transactional Replication on SQL 2008.  You can view this video from the BLOG or double-click to open in YouTube.  He did a great job showing the Peer-2-Peer Wizard and explaining how it all comes together in a 5 minute video. For demonstration purposes
Read More »

Programming Replication Management Objects RMO

Eric Burgess | Microsoft SQL Server Escalation Services You can programmatically setup and configure Merge Replication using Replication Management Objects (RMO). How to: Create a Pull Subscription (RMO Programming) http://msdn.microsoft.com/en-us/library/ms147314.aspx Replication in SQL Server Express http://msdn.microsoft.com/en-us/library/ms165700(SQL.90).aspx SQL Server Express does not include the SQL Server Agent, which is typically used to run replication agents. If
Read More »