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 ...
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.
