Disaster recovery of SQL

You can restore either the entire server, including the SQL databases, from full system backups, or restore only the SQL databases to a newly installed or other available SQL server.

Restoring the entire server, including the SQL databases has the added benefit of recovering other applications and data that may have resided on the server at the time of failure, and can be accomplished using one of the following methods:

To restore only the SQL databases, review the following:

More Information

Redirecting restores for SQL

Recovering SQL manually