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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
