O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring Replication

Replication is configured from SQL Server Management Studio. There are several major steps that must be followed in order to configure replication. These steps are:

  1. Configure the distributor

  2. Configure the publication

  3. Configure one or more subscribers

Without a distributor, you cannot configure replication. The distributor can be on the same system as the publisher, the same system as the subscriber, or on its own system. Let’s look at these steps in some detail.

Configure the Distributor

The distributor is configured from SQL Server Management Studio:

  1. In Object Explorer view, connect to the server instance of your choice, and then expand the server’s Databases folder.

  2. In the navigation pane, right-click Replication and select Configure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required