Chapter 17. Managing Log Shipping and Database Mirroring

You should strongly consider using log shipping and database mirroring in just about any environment in which you deploy Microsoft SQL Server 2008. Log shipping and database mirroring are disaster-recovery solutions designed to help improve the availability and quick recovery of 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 configuration, ...

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