Restore MS SQL Server Database

Backup Agent for Windows offers Microsoft SQL Server cloud backup and restore. This chapter explains how to restore MS SQL data with MBS for Windows.

How to Restore MS SQL Database

1. Run your Backup Agent.

2. Click Restore.

3. Use the Restore Wizard to select cloud storage where 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 runs. Click Next.

5. Select one of the options:

• Restore MS SQL Server Database (restores MS SQL Server database to selected SQL Server)
• Restore MS SQL Server backup files (just downloads database 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. For Restore MS SQL Server Database: select SQL Server Instance from the drop-down list and choose the type of Authentication.

For SQL Server Authentication:

Specify your Login and Password.

10. Click Next.

11. Select the databases to be restored. Click Next.

12. For Restore MS SQL Server Database only:

You may take one or two actions:

• You can change the original database name to restore it under another name,
• You can overwrite the existing database using the Overwrite the existing database option.

13. Click Next.

14. For Restore MS SQL Server Database only:

Select Data file folder and Log file folder. Specify a File name template.

15. For Restore MS SQL Server backup files only:

Specify a destination folder and a backup file template. Click Next.

16. 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.

17. If you restore data from the S3 Glacier Flexible Retrieval or Glacier Deep Archive storage classes, specify Smart Restore options.
18. Specify the notifications options, then click Next.

19. Review the summary. After you are sure that the selected options suits you, click Next.

20. Click Finish to complete MS SQL restore plan creation.

Once you created the MS SQL restore plan, you can run it immediately or whenever you want.