Microsoft® SQL Server 2012 Unleashed

Data Replication

One of the strongest and more stable Microsoft options that can be leveraged for disaster recovery is data replication. Not all variations of data replication fit this bill, though. In particular, the central publisher using either continuous or very frequently scheduled distribution is very good for creating a hot spare of a SQL Server database across almost any geographical distance, as shown in Figure 59.8. The primary site is the only one actively processing transactions (updates, inserts, deletes) in this configuration, with all transactions being replicated to the subscriber, usually in a continuous replication mode. The subscriber at the DR site is as up-to-date as the last distributed (replicated) transaction from the ...