Restore MS SQL Server Backup 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 Online Backup for Windows.

How to Restore MS SQL Server Backup Files

1. Run your Backup Agent.
2. Click Restore.

3. Use the Restore Wizard to select a backup storage to restore from.

4. On the Plan Name screen, select whether to run the restore just once or to save a created restore plan for further use. Click Next.

5. Select the Restore MS SQL Server backup files option to download backup files.

6. Click Next.

7. Select one of the version options for the data to be restored:
   • Latest version
   • Point in time

8. Click Next.
9. Select the databases for restore. Click Next.

10. Specify the restore options: the path to the destination folder and a backup file template. You can create a folder for each database.Click Next.

11. For the data encrypted on the client side, select the "Decrypt encrypted files with the following password" option. Enter your password and re-enter in to confirm, then click Next.

12. (Optional) If you restore data from the S3 Glacier Flexible Retrieval or Glacier Deep Archive storage classes, specify Smart Restore options.

13. If you selected to save a created restore plan for further use, select schedule options, then click Next.

14. (Optional) Specify pre-restore and post-restore actions

15. Specify the notifications options, then click Next.

216. Review the summary. After you are sure that the selected options suit you, click Next to create the restore plan.