Restore MS SQL Server Database

With MSP360 Managed Backup, you can restore backed-up Microsoft SQL Server databases. This chapter covers the following topics:

• Create New MS SQL Restore Plan
  • Plan Name
  • Select Backup Storage
  • Select Computer
  • Select Backup
  • Select Restore Point
  • SQL Server Instance
  • Restore Source
  • Destination
  • Encryption
  • Schedule
  • Pre / Post Actions
  • Notification
• Run Restore Plan
• Edit Restore Plan
• Delete Restore Plan

Step 1

In the Management Console, open the Backup > Computers page.

Step 2

Find the computer hosting the MS SQL instance to which you want to restore a previously backed-up database or databases, then click the computer name or the Configure icon in the Backup Plan Status column.

Step 3

On the side panel, expand +Add new plan to select MS SQL database restore plan. The restore plan wizard starts.

Step 4

The first step when creating a new MS SQL database restore plan is to decide whether to run it immediately after creation or save it for later by giving it a name. * Select the Run restore once option to restore a backup only once. * Select the Save Restore Plan option to save the plan configuration for future use. Specify the name of the plan.

Step 5 (optional)

This step is skipped if you use the backup storage browser to create the plan.

Select the storage that contains the desired data.

Step 6 (optional)

This step is skipped if you use the backup storage browser to create the plan.

Select the computer associated with the backup that you would like to restore.

Step 7

Next, you will be presented with a list of available backup types for the selected host. Select the “SQL Server Instances” option to continue.

Step 8

The next step is to select the desired point in time to restore to. Select the latest version or a specific restore point from the list below.

Step 9

Next, you will be prompted to select the SQL Server instance as well as specify the credentials to be used by the application.

• SQL Server Instance: Select the instance containing the database to be restored from the list. Note that only local instances can be selected.
• Authentication: Choose between Windows or SQL Authentication. If “Windows Authentication” is selected, the application will run the restore 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.

Step 10

Next, select the source of the backup to be restored, then select which databases to restore from the list.

Step 11

The next step asks you to provide the paths the database files will be restored to, and you will be given options to overwrite an existing database or restore the database with a new name.

Select one of the following actions:

• You can close existing connections to the destination database.
• You can overwrite the existing database using the Overwrite the existing database option.

When you select databases from the list, they will be restored with their existing names by default, but if you would like to restore a database under a new or different name, type the new name into the “Restore As” field.

Step 12

If the backed-up data was encrypted, the next step will be to enter the encryption password for decryption. If the password is incorrect or missing, the restore plan will fail, and you will need to edit the plan to input the correct password.

Step 13

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

Step 14

If you opted to save the restore plan, the next step is to specify how the plan should be triggered.

• No schedule (run manually): Use this option only when you wish to execute the restore manually.
• Specific date: Use this to schedule a one-time restore at the specified date and time.
• Recurring: This option enables you to schedule recurring restorations based on the criteria in the fields below.

Step 15

With Recurring selected on the previous step, you are then prompted to define the time and frequency of the plan execution.

Step 16

The Pre/Post Actions page allows the execution of custom scripts before and/or after the restore task runs.

Step 17

The final step is to review notification settings. The settings applied at the company level are selected by default; however, you can also specify custom options per plan.

Step 18

Click Save when you are happy with your selections. If the plan is set to run only a single time and has no set schedule, it will automatically start. Otherwise, if it is set to run only once and is scheduled, it will display in the list of plans until the scheduled time. If it is only set to run once, when it completes successfully, it will remove itself from the list of plans. Only restore plans that are saved will remain in the list for future use.

| Top |

Run the Restore Plan

To run the restore plan, proceed as follows:

1. Open the Backup > Computers page in the main menu.
2. Find the required computer, then click the Configure icon in the Backup Plan Status column.
3. On the side panel, click the Start button.

| Top |

Edit the Restore Plan

To edit the restore plan, proceed as follows:

1. Open the Backup > Computers page in the main menu.
2. Find the required computer, then click the Configure icon in the Backup Plan Status column.
3. On the side panel, click the Edit icon below the backup plan tile.

4. Make the required changes, then click Save.

| Top |

Delete the Restore Plan

To delete the restore plan, proceed as follows:

1. Open the Backup > Computers page in the main menu.
2. Find the required computer, then click the Configure icon in the Backup Plan Status column.
3. On the side panel, click the Delete icon below the backup plan tile.

4. Confirm the plan deletion.

| Top |