O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Replication topologies

Mainly, there are three different topologies that are used while designing and implementing replication: Central Publisher, Central Subscriber, and Publishing Subscriber. Let's have a quick look at each of them now.

  • Central Publisher: This is a very common and general type of design. In this topology, there will be a single Publisher and one or more Subscribers. The Distributor server can be the same machine as the Publisher, but it is recommended to use a different physical server as the Distributor.
  • Central Subscriber: This type of design is used for reporting or OLAP or BI kind of requirement, when business data needs to be analyzed from a single location, no matter which location it comes from — be it from a physically ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required