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

How Peer-to-Peer Replication works

Let's look at a scenario with the help of the following diagram. P2P replication is configured on two servers — Server A and Server B. There are four, or more than four, workstations connected to the Application Server, which sends and receives data from the database servers (in this case, Server A and Server B).

How Peer-to-Peer Replication works

Now, Server A and Server B have replication set up, which has almost identical data spread between two of them. If we take a look, there are thick bi-directional lines that indicate the bi-directional data flow between Server A and Server B. On the other hand, the thin lines show the traffic routed from ...

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