keeping in view the sensitivity of topic, a DBA must pay full attention to be prepared for recovery from any type of disaster. Following are just very general guidelines, but the task requires planning and practice.
- You must create a disaster recovery plan and include every detail you will need to rebuild your servers.
- As your SQL Servers change over time, don’t forget to update your disaster recovery plan
- Write the disaster recovery plan so that any computer literate person will be able to read and follow it. Do not assume a DBA will be rebuilding the servers.
- Fully test your disaster recovery plan at least once a year.
Chosen from SQL Server DBA best practices By Brad M.mcGehee