Many would argue that the single, most important job of a SQL Server database administrator is to be able to recover your database in the event of loss or damage. Pro SQL Server Disaster Recovery helps you meet that goal by showing you how to think about and plan for potential problems. You’ll learn to anticipate and reduce the likelihood of a disaster, and to mitigate the effects of a disaster when one does occur. Perhaps most importantly, you’ll learn how to prepare so that you can return a system to its normal state quickly, ensuring system availability and the continued success and operation of your business.

This book shows you how to implement an effective disaster recovery strategy for SQL Server 2005 databases. It covers:

• Real–world examples of data loss and what might have been done to prevent it
• A systematic, problem–based approach to designing a disaster recovery plan
• Pitfalls one might encounter, and how to deal with them
• Team dynamics, and the soft–side of disaster planning
• New technology in SQL Server 2005 and 2008 that takes disaster recovery beyond the simple backup/recovery plan
• When and why to use disaster recovery features, as opposed to just describing how they work

Download here.