Troubleshooting and Disaster Recovery › Microsoft SQL Server Disaster Recovery › Disaster Recovery Scenario

Disaster Recovery Scenario

A typical disaster recovery scenario consists of the following steps:

1. Reinstall Windows, if necessary.
2. Reinstall CA ARCserve Backup, if necessary.
3. Reinstall the Agent for Microsoft SQL Server and the Client Agent for Windows, if necessary. (The Client Agent is needed to restore Microsoft SQL Server Disaster Recovery Elements.)
4. Perform one of the following steps as appropriate:
   • If you have a Microsoft SQL Server Disaster Recovery Elements session, restore it.
   • If an offline backup exists, restore it.
   • If you do not have an offline backup or a Disaster Recovery Elements session, and you have the Microsoft SQL 7.0 or 2000 rebuildm.exe utility, use the utility to recreate the master and model database. For SQL 2005 and 2008, this is an ability of the SQL Server installation software. For more information, see the Microsoft documentation.
   • If an offline backup or Disaster Recovery Elements backup do not exist and you do not have the Microsoft SQL rebuildm.exe utility, reinstall the Microsoft SQL Server or MSDE-based application.
5. Restore the [master] database.
6. Restart Microsoft SQL Server in normal, multi-user mode.
7. Restore the [msdb] database.
8. Restore the model database.
9. Restore all other databases and transaction logs, except the distribution database for replication.
10. If replication is being used, restore the replication database.