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 »

Walkthrough setting up SQL Replication Distributor using TSQL commands

The scripts below and the video capture walkthrough setting up a Microsoft SQL Server Replication Distributor using SQL commands. As discussed in previous posting, the Distributor is a key role in Replication.  It serves as a “cache” holding transactions for Transactional Replication and history tracking for all types of Replication.  I’ve highlighted some of the
Read More »

High Level Transactional Replication Process Flow

High Level Transactional Replication Process Flow I’ve posted this flow before on my BLOG but I wanted to include the stored procedure calls used by Transactional Replication. While troubleshooting Replication performance/latency we’ll try and identify which stored procedure executing from which Replication Agent has the highest IO or highest CPU usage. These usually are a
Read More »