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 Backup Agent for Windows.

How to Restore MS SQL Database

To restore MS SQL databases in Backup Agent:

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

3. Once the wizard starts, click Next to advance to the next step.

4. Use the Restore Wizard to select the backup storage to restore from (restore source). If the desired storage is not in the list, you can click Add new storage account to add it.

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

6. With the type of restore selected, the next step is to select the computer associated with the backup that you would like to restore.

7. Select the Restore MS SQL Server Database option to restore to an SQL Server instance that will be selected in the next steps.

8. Select one of the version options for the data to be restored:
   • Latest version
   • Point in time. If there is no exact match for the point in time selected, the application will automatically select the closest previous restore point.

9. Select the instance containing the database to be restored from the list. Note that only local instances can be selected.
   • SQL Server Instance: Select the instance containing the database to be backed up from the list.  Note that only local instances can be selected.
   • Authentication Type: Choose between Windows or SQL Authentication.  If “Windows Authentication” is selected, the application will run the backup as the local service account.
     • User Name: If “SQL Server Authentication” was selected, enter the user name in this field.
     • Password: If “SQL Server Authentication” was selected, enter the password for the specified SQL user here.
   • Check if the specified account has necessary permissions to perform backup: The application will check for the appropriate permissions prior to attempting to backup the database.  It is recommended to use this option to prevent unexpected failures.
   • Use secure connection (SSL/TLS): Enabling this will allow the application to connect to the SQL instance using encryption, if configured on the database host.

10. Select the databases to be restored. After selecting the database(s) to be restored, you will be given options to overwrite an existing database or restore the database with a new name. Click Next.

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

11. Select the data file folder and the log file folder. Specify a file name template.

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

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

14. If you chose to save the created restore plan for further use, select schedule options, then click Next.

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

16. Specify the notification options, then click Next.

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

Run the Restore Plan

To run the restore plan, proceed as follows:

1. On the Restore plans tab in Backup Agent, select the restore plan to run.
2. Click the Start button.

Edit the Restore Plan

To edit the restore plan, proceed as follows:

1. On the Restore plans tab in Backup Agent, select the restore plan to edit.
2. Expand the plan, then click the Edit icon below the restore plan tile.

3. Make the required changes, then click Save.

Delete the Restore Plan

To delete the restore plan, proceed as follows:

1. On the Restore plans tab in Backup Agent, select the restore plan to delete.
2. Expand the plan, then click the Delete icon below the restore plan tile.

3. Confirm the plan deletion.