Previous Topic: Restore by Session in Microsoft SQL Server 2000, 2005, 2008, or 2012 EnvironmentsNext Topic: Troubleshooting and Disaster Recovery

Backing Up and Restoring in Cluster Environments › Perform Disaster Recovery in Microsoft SQL Server 2000, 2005, 2008, or 2012 Cluster Environments

Perform Disaster Recovery in Microsoft SQL Server 2000, 2005, 2008, or 2012 Cluster Environments

If a disaster occurs, you can recover your SQL database in a cluster environment.

Follow these steps:

  1. Reinstall Microsoft SQL Server and re-create the Microsoft SQL Server virtual server.
  2. Reinstall the Agent for Microsoft SQL Server, if necessary.
  3. Restore the Microsoft SQL Server [master] database.
  4. Restart Microsoft SQL Server in normal, multi-user mode and restore the rest of the databases, beginning with msdb, and then model, ending with the distribution database for replication, if any.

Note: For more information about recovering from a disaster, see the Disaster Recovery Option Guide.