Chapter 27. Log Shipping and Database Mirroring

Log shipping has been a method for creating a standby database since SQL Server 2000. In fact, if you count homemade methods, log shipping has been around even longer. In SQL Server 2005, log shipping is still available, but it has been enhanced with the addition of SQL Server mirroring. SQL Server mirroring builds on log shipping technology but allows the standby system to be completely in sync with the primary system.

In this chapter, you will learn how to configure and manage both log shipping and database mirroring. As you have seen in Chapter 25, both of these can be used as a disaster recovery solution designed to keep your company in business in the unfortunate ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.