O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Disaster Recovery Patterns

In general, you should consider three main DR patterns when trying to achieve Level 1 through Level 4 DR.

Active/Passive DR Sites Pattern

Figure 59.2 illustrates this typical DR configuration, which is probably the most common in the world (for those who are doing DR). It involves a primary site (your normal environments in which you do business day in and day out) and a passive DR site. This passive DR (alternative) site can be anything and anywhere. It could be a “hot” alternate site that is ready for you to apply a current database backup to (and application image, too), or it could be a “cold” alternate site that you have to either go out and lease, co-locate with, or build completely from scratch. Microsoft also ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required