Restore MS SQL Files in Backup Agent
Backup Agent for Windows offers Microsoft SQL Server backup and restore. This chapter explains how to restore MS SQL backup files in Backup Agent for Windows.
Step 1
In Backup Agent, click Restore in the horizontal menu.
Step 2
Once the wizard starts, click Next to advance to the next step.
Step 3
The next step will prompt you to select the source for the restore.
If the desired storage is not in the list, you can click Add new storage account to add it.
Step 4
Next, you will be given the option to either run the restore once or to save it to run later.
Run restore once will execute the restore immediately upon completing the wizard. There is no option to schedule this type of restore.
Save restore plan will allow you to schedule the plan to run at a later time and also schedule repeating restorations if needed.
It is recommended to use a descriptive name that will distinguish the backup from others.
Step 5
With the type of restore selected, the next step is to select the computer associated with the backup that you would like to restore.
Step 6
Next, you will be presented with a list of available backup types for the selected host. Select the MS SQL backup files option to continue.
Step 7.
Next, you will be given a choice of what point in time you would like to restore the database to.
If there is no exact match for the point in time selected, the application will automatically select the closest previous restore point.
Step 8
Select the database backup that you would like to restore.
Step 9
The next step asks you to provide the paths the database files will be restored to.
Step 10
Next, the application will prompt you to enter the password used if the backup was encrypted. If it was not encrypted, simply click “Next”.
Step 11
Next, you are prompted to set the schedule for your restore plan, which will allow it to run autonomously, or you can select No Schedule to run the plan manually, if needed.
Enabling the Run missed scheduled backup immediately when computer starts up option will ensure that the restore process begins automatically upon startup if the last restore was not able to start at the scheduled time for any reason. This option is recommended for desktops and laptops.
Do not use the Stop the plan if it runs for: option if you have a slow or unstable internet connection.
Step 12
The Pre/Post Actions page allows the execution of custom scripts before and/or after the restore task runs.
Step 13
Specify notification settings.
Step 14
The next step of the wizard displays a summary of the selections made throughout the process. Once you have reviewed your selections, click Next.
Step 15
After you click Next on the previous step, the restore plan is created. The final step is to acknowledge this and determine whether to run the restore immediately or for it to wait until the next scheduled occurrence.
Run the Restore Plan
To run the restore plan, proceed as follows:
- On the Restore plans tab in Backup Agent, select the restore plan to run.
- Click the Start button.
Edit the Restore Plan
To edit the restore plan, proceed as follows:
- On the Restore plans tab in Backup Agent, select the restore plan to edit.
- Expand the plan, then click the Edit icon below the restore plan tile.
- Make the required changes, then click Save.
Delete the Restore Plan
To delete the restore plan, proceed as follows:
- On the Restore plans tab in Backup Agent, select the restore plan to delete.
- Expand the plan, then click the Delete icon below the restore plan tile.
- Confirm the plan deletion.