MS SQL recovery requirements

Backup Manager lets you recover databases powered by Microsoft SQL Server.

In order to restore MS SQL, the following requirements must be met:

  • Backup Manager must be installed on the machine that you want to recover the data to. It can be your MS SQL Server or any other Windows computer (Windows 8 or greater, see Supported features for a full list).
  • MS SQL should be installed

    • If MS SQL is not installed, you can restore to a flat database and then import the file into MS SQL afterward.

Recovery options

Like with other data sources, you can recover MS SQL databases to either of the following:

  • Original location
  • New location

Recovery to the Original Location

To recover MS SQL to the original location, leave the Restore to field blank. In that case the recovered data will be merged with the current data.

This feature requires SQL Server installation.

If you include the master database into your recovery selection, stop the SQL Server service before you start the recovery:

  1. Open the Start menu or Run
  2. Type services.msc
  3. Hit enter
  4. Right click the SQL Server service (MSSQLSERVER) and click Stop

When the recovery completes, you will need to start the SQL Server service. It can be done through the Services Console by right clicking and selecting Start, or by rebooting the machine.

Recovery to a New Location

You can recover MS SQL to a new location, which does not need the SQL Server installation. When the recovery completes, you will need to copy the recovered data to the target location manually.