How to Restore MS SQL Server

MBS for Windows enables service providers an opportunity to offer Microsoft SQL Server cloud backup and restore to their customers. This article explains how to restore MS SQL data with MBS for Windows.

How to Restore MS SQL Database

  1. Run your MBS Agent.

  1. Click the "Restore" icon.

  1. Use the Restore Wizard to select a cloud storage where to restore from.

  2. On the "Plan Name" screen, select whether to run the restore just once or to save a created restore plan for the further runs. Click Next.

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

  1. Select one of the version options for the data to be restored:
  • Latest version
  • Point in time
  1. Click Next.

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

  1. Click Next.

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

  1. For Restore MS SQL Server Database only:

You may take one or two actions:

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

  1. For Restore MS SQL Server Database only:

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

  1. For Restore MS SQL Server backup files only:

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

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

  1. For the data backed up to Amazon Glacier:

Specify Smart Restore options.

  1. Specify the notifications options, then click Next.

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

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

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