Category: Try This

Walkthrough Setting up a SQL 2008 Replication Distributor using TSQL Scripts

Share this PostIn 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
Read More »

Walkthrough Setting up SQL 2008 Peer-2-Peer Replication

Share this PostSudharshan 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
Read More »

Walkthrough setting up SQL Replication Distributor using TSQL commands

Share this PostThe 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
Read More »