You will need the most recent backups of all databases and the output from the scripts in Appendix A – Appendix D. After locating everything you will need, perform the following steps.

1. From other server’s Server Manager, remove the Old server from the domain.
2. Install NT Server, any application, network settings, and users. Use the same server name and IP address.
3. Install any NT services packs
4. Perform a SQL Server installation
5. Install any SQL Server service packs
6. Restore any application data
7. Reboot the Server
8. Run the device creation script generated from the script in Appendix B (<filename>)
9. Run the database creation script generated from the sp_help_revdatabase procedure with a for load option (<filename>)
10. Restore the master database
11. If master fails to restore cleanly
1. Rebuild master
2. Turn on allow updates
3. BCP in the file from syslogins (<filename>)
4. Turn off allow updates
5. Do NOT attempt another restore of master and do NOT restore msdb
6. Run script to recreate all dump devices
7. Run script to recreate all tasks with the exception of replication tasks
8. Reset configuration options (<filename>)
12. Restore the msdb database
13. Restore each of the user databases
14. Verify that all databases and all objects have been created properly.
15. Verify that all operators, tasks, and alerts have been set properly
16. If replication is installed, remove replication
17. If replication is installed, verify all replication components have been eliminated
18. If replication is installed, reinstall replication
19. If replication is installed, verify and test installation of all components
20. Open the server for production.

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