Recovering SQL Server databases from a disk backup

This section describes how to recover SQL Server databases from a disk backup.

For the instructions how to find out the database paths, refer to "SQL Server database files".

To recover SQL Server databases

  1. Connect the console to the machine on which you are going to perform the operation.
  2. Navigate to the vault containing the disk backup with the SQL Server database files.
  3. Click the Data view tab. In the Show list, click Folders/files.
  4. Select the required SQL Server database files and click Recover. By default, the data will be reverted to the state of the latest backup. If you need to select another point in time to revert the data to, use the Versions list.
  5. On the recovery page under What to recover section:
    1. In Data paths, select Custom.
    2. In Browse, specify a folder where the files will be recovered to.

      Note: We recommend that you recover the SQL server database files to a folder local to the SQL Server, since all of the SQL Server versions earlier than SQL Server 2012 do not support databases located on network shares.

    3. Leave the rest of the settings "as is" and click OK to proceed with recovery.
  6. After the recovery is complete, attach the databases according to the instructions described in the "Attaching SQL Server databases" section.

    Details. If for any reason you did not recover all of the SQL Server database files, you will not be able to attach the database. However, the Microsoft SQL Server Management Studio will inform you about all the paths and names of the missing files and it will help you to identify what particular files the database consists of.