8.2. Implement Replication

Replication is one of the oldest data distribution techniques supported by SQL Server. The purpose of replication is to copy data or transactions from one server to another. While this can be a very effective distribution technique, there is no support for failover or transparent client redirection, so it is a marginal availability solution in most cases. Replication can still be an excellent data distribution technique, however.

8.2.1. Understand Types of Replication

SQL Server 2008 supports three major varieties of replication:

Snapshot replication

This approach focuses on copying data from one database to another. Entire data pages are copied from the publisher to the subscriber, meaning that the data is aging ...

Get SQL Server® 2008 Administration: Instant Reference now with the O’Reilly learning platform.

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