Configuring SQL Server Replication

After configuring the replication of files and folders required to build the deployment infrastructure, configure SQL Server to replicate the MDT DB.

Note It is also possible to maintain only a single central MDT DB; however, by maintaining a replicated version of the MDT DB, greater control can be maintained over data transferring across the wide area network (WAN).

SQL Server 2005 uses a replication model that is similar to a magazine distribution model:

1. A magazine is made available (published) by a publisher.

2. Distributors are used to distribute the publication.

3. Readers can subscribe to a publication so that that publication is delivered to the subscriber periodically (a push subscription).

This terminology is used through the SQL Server replication setup and configuration wizards.