As Today's businesses become increasingly reliant on the information they store in their various databases, so the effective protection of that data becomes ever-more critical. Potential 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 you how to implement an effective disaster recovery strategy for SQL Server 2005 and 2008 databases. You'll learn about powerful tools and features - such as Database Snapshots and Mirroring - for data backup and disaster recovery that are present in SQL Server 2005, and that are enhanced in SQL Server 2008. Users of SQL Server 2000 will find that the options for handling disaster recovery have increased dramatically. This book explores those options by examining the technical details of disaster recovery features and then applying that knowledge to practical scenarios. Also covered are fundamental changes to disaster recovery capabilities, and common issues to expect when using new features.