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:
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 ...