Sunday, February 07, 2010

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 key options at each phase.

http://blogs.msdn.com/chrissk/archive/2010/01/28/troubleshooting-transactional-replication-part-1.aspx

As you can see from SQL Server Management Studio, Databases, there is no Distribution database.  This confirms Replication Distributor has not yet been configured on this server.

Read more: MSDN

Posted via email from jasper22's posterous