The procedure for recovering from this would be the same as the restore from the Backup Server after a complete server failure once replacement hardware is procured.

Physical location destroyed

Obviously, you can’t get more serious than this. In order to recover from this, you essentially have to do a full server restore for every server. Each of the servers should be prioritized by business function and the most critical server restored first. Follow these procedures:

1. Configure hardware.
2. Install NT, SQL Server, service packs, and all supporting software
3. Verify proper installation of all components
4. Restore master
5. Restore msdb
6. Restore each user database
7. Verify that all databases and objects have been properly created
8. Open for production
9. Repeat steps 1 – 8 for each server to be recovered
10. If replication is needed, install replication
11. If replication is installed, verify replication performing properly

If any errors are encountered, you will need to handle them as outlined above.

Technical Support

Offsite Tape Storage
Support number:
Account number:

Microsoft
Support ID:
Premier Support: (800) 936-3200
Pay Per Incident Support: (800) 936-5900
Priority Support: (800) 936-4900
Website: http://www.microsoft.com/support

Compaq
Support ID:
Phone: 1-800-652-6672
Website: http://www.compaq.com/support

6.5 Disaster Recovery Plan 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18