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 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 Database to restore MS SQL Server database to selected SQL Server.

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 SQL Server Instance from the drop-down list and choose the type of authentication.

10. For SQL Server Authentication, specify your login and password. Click Next.

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

12. Select one of the following 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. Select data file folder and Log file folder. Specify a file name template.

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

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

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

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

19. Specify the notifications options, then click Next.

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