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 new distributors, enabling publishers, enabling publication databases, updating existing distributors, 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 might need to update clients and applications that ...
Get Microsoft® SQL Server® 2008 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.
