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 replication works

In the diagram under the Components of the replication section at the Publisher end, we can see that all the data marked for replication is either pulled or pushed at the Distributor database, which later is pulled at or pushed by at the Subscriber end. Now, all this work has to be done on a continuous or a scheduled interval, based on the company policy. The process of replication creates some agents whose work is to send and receive data. There are different types of replication agents for different types of replications. Let's go through each of them, although we will have detailed information on each of them in a separate chapter.

  • Snapshot Agent: The Snapshot Agent is typically used with all types of replication. The ...

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