Recovering SQL Server data

In case of a disaster, you can recover an entire SQL Server by restoring all its disks from a disk backup. If you followed the recommendations outlined in the "Backing up an application server" section, all of the SQL Server services will be up and running without additional actions. The server data will be reverted to the state that it was at the time of backup.

To bring a backed-up database back to production, recover the database files from a disk backup. For details, see "Recovering SQL Server database files from a disk backup".

If you only need temporary access to the backed-up databases for data mining or data extraction, mount a disk backup and access the required data. For details, see "Accessing SQL Server databases from a disk backup".

In this section

Recovering SQL Server databases from a disk backup

Accessing SQL Server databases from a disk backup

Attaching SQL Server databases