Diagnose causes of failures. Failure types include database failures, physical server failures, and SQL Server service failures.
Plan for fault-tolerance.
Recover from a failure of SQL Server 2005.
Recover from a database disaster.
Plan a strategy.
Restore a database.
Configure logins.
Recover lost data.
Maintain server and database scripts for recoverability.
Salvage good data from a damaged database by using restoration techniques.
One of the key responsibilities of a database administrator (DBA) is to design and implement an appropriate data recovery plan for a SQL Server 2005 database solution. Designing an appropriate data recovery plan involves more than just designing an appropriate database backup strategy. This chapter will examine the other important facets that apply. As always, it is important to analyze what you are protecting against, so don’t forget to include the possibility of accidental or malicious data modification in your data recovery plan.