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

Log Shipping

As you can see in Figure 59.10, log shipping is readily usable for the active/passive DR pattern. You must understand that log shipping is only as good as the last successful transaction log shipment. Frequency of these log ships is critical in the RTO and RPO aspects of DR. This is really not a real-time solution. Even if you are using continuous log shipping mode, there is a lag of some duration due to the file movement and log application on the destination.

Image

FIGURE 59.10 Log shipping configuration for active/passive DR.

Remember, log shipping is destined to be deprecated by Microsoft (unofficially announced). So it is perhaps ...

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