Previous Topic: Suggested Database Restore Sequence

Next Topic: Configuring Microsoft SQL Server Security Settings

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:
  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.