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 7 or greater).
- MS SQL must be installed
If MS SQL is not installed, you can restore to a flat database and then import the file into MS SQL afterward.
Like with other data sources, you can recover MS SQL databases to either of the following:
- Original location
- Intermediate 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. Note that the 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.
- Start the Services Console (services.msc).
- Right-click SQL Server (MSSQLSERVER) and then choose Stop from the context menu.
When the recovery completes, you will need to start the SQL Server service. It can be done through the Services Console or by rebooting the machine.
Recovery to an intermediate location
You can recover MS SQL to an intermediate location. It does not need the SQL Server installation. When the recovery completes, you will need to copy the recovered data to the target location manually.