Distributed Data Guidelines

Image Distribute for disaster recovery—Those organizations that have a disaster recovery (DR) requirement that they would like to fulfill with distributed data can use several options. The new AlwaysOn Availability Group capabilities are designed for DR and high availability. Another approach is to use traditional bit-level stretch clustering (using third-party products such as from Symantec) to your disaster recovery site. And another is simple log shipping to a secondary data center at some interval. Other options include database mirroring (asynchronous mode), periodic full database backups that are sent to another site ...

Get Microsoft® SQL Server 2012 Unleashed 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.