Potential database disasters can arise from natural causes like floods and hurricanes, to user errors, to media or hardware failure. The process of disaster recovery involves mitigating the likelihood of a disaster and the process of returning the system to a normal state. It is intricately linked with the important areas of availability and business continuity, which ensure day-to-day activities can continue regardless of the problem.
This book shows readers how to implement an effective disaster recovery strategy for SQL Server 2005 and 2008 databases. It details powerful tools and features for data backup and disaster recovery, such as Database Snapshots and Mirroring, which are present in SQL Server 2005 and enhanced in SQL Server 2008. Written by an acknowledged expert in the field who has high community recognition, it covers all new 2005 and 2008 features, with broad appeal to users of SQL Server 2000 on up as well as third-party database users.