Walkthrough Setting up a SQL 2008 Replication Distributor using TSQL Scripts

In this video •Configuring Distributor is first step in setting up SQL Server Replication •We verify Distributor is not configured •Walkthrough setting up SQL Replication Distributor using TSQL Scripts •Highlight of key parameters •Show how to generated Distributor TSQL commands automatically from SQL Server Management Studio Remember, you can double-click the video to view FULL
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 »

Using Windows Synchronization Manager on x64 to Synchronize Replication

Windows Synchronization Manager on x64 SQL 2005 BOL topics describe how to launch the Windows Synchronization Manager to synchronize a subscriber. How to: Synchronize a Subscription Using Windows Synchronization Manager (Windows Synchronization Manager) http://msdn.microsoft.com/en-us/library/ms151863.aspx On x64 system, the BOL steps will start the x64 Win Sync Manager not the 32bit version.  The x64 bit will
Read More »