O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Microsoft SQL Server Disaster Recovery Solutions

There are many disaster recovery solutions that can be used with SQL Server. Some of these solutions are SQL Server–specific, and other solutions are independent of SQL Server. Some solutions work regardless of the software involved in the system. Our discussion of the options assumes that waiting days for hardware replacement is unacceptable. You will see that each of the options varies in cost and recovery speed. Although the SQL Server 2005 features and other disaster recovery options provide high availability, your application code should be able to handle the failover to the disaster databases as well.

Using Database Backups for Disaster Recovery

The most basic, and probably the most common disaster ...

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