Chapter 17. Managing Log Shipping and Database Mirroring

You’ll want to strongly consider using log shipping and database mirroring in just about any environment where you deploy Microsoft SQL Server 2008. Log shipping and database mirroring are disaster-recovery solutions designed to help improve availability and quickly recover SQL Server 2008. They do this by establishing a standby database that can be used if your production database becomes unavailable because of an outage or disaster. Because log shipping and database mirroring create a copy of a database, they can help protect you against many types of data loss as well. For example, with a delayed log shipping ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant 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.