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…


ReplTalk Start Here

START HERE for table of contents into ReplTalk BLOG postings This page was created to help organize the key ReplTalk MSDN blog postings by the Microsoft SQL Server Replication Support Team.  We hope these postings provide some insight into how Replication works while we peel back some of the layers in these postings.  Since we…


Walkthrough setting up SQL Replication Distributor using TSQL commands

Walkthrough setting up SQL Replication Distributor using TSQL commands –Chris Skorlinski–Microsoft SQL Server Escalation Services 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…


First Steps in Troubleshooting Replication

First Steps in Troubleshooting Replication Chris SkorlinskiMicrosoft SQL Server Escalation ServicesReplTalk START HERE Why does Microsoft SQL Support ask me all those questions?  Why can’t they just show me how it work or fix the problem?  Well wish it was that simple, but for us to help you we need to get the “big picture”. …


TSQL Commands to generate and track Tracer Tokens

TSQL Commands to generate and track Tracer Tokens Tracer Tokens are a great way to monitor the flow of transactions from the Publisher to the Subscriber.  These can be generated and tracked from SQL Server Replication Monitor or via TSQL commands.  This post includes some of the common TSQL commands used to generate and track…


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. http://blogs.msdn.com/chrissk/archive/2010/01/28/troubleshooting-transactional-replication-part-1.aspxhttp://blogs.msdn.com/chrissk/archive/2010/01/29/slides-from-talk-i-gave-on-troubleshooting-transactional-replication.aspx 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…


What is a “virtual” Subscription in Transactional Replication

What is a “virtual” Subscription in Transactional Replication The SQL Replication system table syssubscriptions contains one row per published article per subscriber.  Notice the “virtual” subscriber. With the immediate_sync property is set to true, “virtual” subscriptions are created as placeholders for retaining generated snapshot (transactions). These “virtual” subscriptions are activated just like normal subscriptions by…


SQL Server Merge Replication Best Practices

SQL Server Merge Replication Best Practices “REPL TALK” Chris SkorlinskiMicrosoft SQL Server Escalation Services I’m posting a collection of SQL Server 2008 Merge Replication Best Practices.  The material below includes text from SQL Books Online, other white papers, KB articles, web postings, and little from experience I gained working with SQL Replication for almost 15…


New Microsoft SQL Replication Focused BLOG

“REPL TALK”  The Microsoft SQL Server Escalation Services team is currently in the processes of setting up this Replication-focused blog.  For now, please check out content on http://blogs.msdn.com/chrissk/. Thanks,Chris Skorlinski