Distributor Administration
As the name indicates, you use distributors to distribute replicated data. When you work with distributors, the core set of administration tasks you will perform includes setting up a new distributor, updating an existing distributor, and deleting distributors.
Setting Up a New Distributor
Setting up a new distributor is the first major step in configuring replication. Before you get started, you should prepare as follows:
Select a replication type—either snapshot, transactional, or merge.
Select a replication model, such as the central publisher model.
Perform any necessary preliminary tasks. To meet certain limitations, you may need to update clients and applications that modify published databases directly.
When you are ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant 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.