Restore MS SQL Server Backup Files

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

• Create New MS SQL Restore Plan
  • Plan Name
  • Select Backup Storage
  • Select Computer
  • Select Backup
  • Select Restore Point
  • 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 Backup > Computers page.

Step 2

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

Step 3

In the side panel, navigate to the Restore plans tab. Click on the +Add New Plan button and select MS SQL files restore plan from the drop-down menu.

Step 4

The first step when creating a new MS SQL restore plan is to decide whether to run it a single time immediately after plan creation, or give it a name and save it for later.

Step 5

Next, select the storage which contains the desired data.

Step 6

With the backup storage selected, the next step is to select the computer associated with the backup which 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.

Step 9

Next, select which database to restore.

Step 10

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.

Step 11

If the backed up data was encrypted, the next step will be to enter the 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 12

Next, 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: Using this option enables you to schedule recurring restore operations based on the criteria in the following step.

Glacier Smart Restore (optional)

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

Step 13

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

In addition to scheduling the restore, other options are available regarding notification and management of long running or missed plans.

Step 14

he Pre/Post Actions page allows the execution of custom scripts before and/or after the running of a backup task.

Step 15

The final step is to review the notifications settings. The default settings applied at the Company level are selected by default, however you are also able to specify custom options per plan.

Step 16

Click on 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, then when it completes successfully it will remove itself from the list of plans. Only Restore Plans which are saved will remain in the list for future use.

| Top |

Run the Restore Plan

To run the restore plan, proceed as follows:

1. On Computers select Remote Management if you use the legacy main menu, or open Backup > Computers page in the new 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. On Computers select Remote Management if you use the legacy main menu, or open Backup > Computers page in the new 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. On Computers select Remote Management if you use the legacy main menu, or open Backup > Computers page in the new 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 |