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