Distributed Data Guidelines
• Distribute for disaster recovery—Those organizations that have a disaster recovery requirement that they would like to fulfill with distributed data can use several options. One is traditional bit-level stretch clustering (using third-party products such as from Symantec) to your disaster recovery site. Another is simple log shipping to a secondary data center at some interval. Keep in mind, though, that log shipping will be deprecated at some point. Other options include database mirroring (asynchronous mode), periodic full database backups that are sent to another site and restored to a standby server, and a few variations of data replication.
• Distribute to satisfy partitioned data accesses—If you have very ...
Get Microsoft® SQL Server 2008 R2 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.
