Replication Topology

Publishers, distributors, and subscribers each play a role in the distribution of data. The method of connecting all these pieces together and their relationship to one another establishes your topology. In a simple topology, the publisher and distributor are located on a single server and there can be one or more subscribers. Specific requirements for distributing data might call for a more complicated topology. If there are hundreds of subscribers to a publication, a single publisher or distributor might not have the resources necessary to manage the heavy processor load and disk I/O. By carefully arranging your publishers and distributors, you could alleviate some of the burden on a server that contains the primary source ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.