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 ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial