After you use Hybrid Backup Recovery (HBR) to back up SQL Server databases to a backup vault, you can restore the SQL Server databases to the original SQL Server instance, another SQL Server instance that uses the same backup vault, or an SQL Server instance in another region.

Prerequisites

SQL Server databases are backed up. For more information, see Back up SQL Server databases.

Background

Before you restore SQL Server databases, note the following points:

  • Currently, the restore paths of SQL Server databases cannot be modified. Therefore, the paths of the destination SQL Server database on the destination SQL Server instance must be the same as the default paths of the source SQL Server database on the source SQL Server instance. If not, the restored SQL Server database cannot be loaded.
    Note To view the default paths of an SQL Server database, you can open the Server Properties dialog box of the SQL Server instance, click Database Settings, and then view the paths of the SQL Server database in the Database default locations section.
  • If the source SQL Server database has more than one .ndf files, you can only restore this database to the destination database that has the same name. If not, the source database cannot be restored.
  • When you restore an SQL Server database from incremental backup, HBR automatically uses full backup to restore the database before using incremental backup.
  • To restore the databases of an SQL Server instance to another SQL Server instance, make sure that the version of the source SQL Server instance is not later than that of the destination SQL Server instance.
  • To restore the primary database of an SQL Server instance, start the SQL Server instance in single-user mode.

Restore an SQL Server database to the original SQL Server instance

To restore an SQL Server database to the original SQL Server instance, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SQL Server.
  3. On the page that appears, click the SQL Server Instance tab.
  4. On the SQL Server Instance tab, find the SQL Server instance to be restored and click Restore in the Actions column.
  5. In the New Restore Task pane that appears, select the source SQL Server instance and click Next.
  6. Select a database to be restored and click Next.
  7. In the Restore Rule step, set the parameters as described in the following table and click Next.
    Parameter Description
    Destination Database The name of the database restored on the destination SQL Server instance.
    Note
    • If you want to use the restored database to overwrite an existing database, enter the name of the existing database in this field and select Override existing database.
    • If you do not want to overwrite an existing database, enter a name that is different from the names of existing databases.
    Restore Policy
    • Most Recent

      Restores the database to the latest available status.

    • Time Point

      Restores the database to the status closest to a specified time point. If you select this option, you must specify a time point.

    • From Snapshot

      Restores the database to a specified backup. If you select this option, you must specify a backup version.

  8. Confirm that all the information is correct and click Create.

Restore an SQL Server database to another SQL Server instance in the same region

The procedure for restoring an SQL Server database to another SQL Server instance in the same region that uses the same backup vault is similar to that for restoring an SQL Server database to the original SQL Server instance. The only difference is that you must select another SQL Server instance as the source SQL Server instance.

SQL Server

For more information about how to restore the SQL Server database to another SQL Server instance, see Restore an SQL Server database to the original SQL Server instance.

Restore an SQL Server database to an SQL Server instance in another region

A backup vault is a repository used by HBR to store backup data in the cloud. You can restore an SQL Server database from a remote mirror vault to an SQL Server instance in another region based on disaster recovery requirements.

Before you can use a remote mirror vault to restore an SQL Server database to an SQL Server instance in another region, you must create a remote mirror vault. For more information about how to create a mirror vault, see Use a mirror vault to back up data across regions.

To restore an SQL Server database to an SQL Server instance in another region, follow these steps:

  1. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SQL Server.
  2. Select the region where a mirror vault resides.
  3. On the SQL Server Instance tab, install a backup client on each node of the source SQL Server instance.
    Note You must select the existing mirror vault whose name starts with [COPY] as the backup vault for the source SQL Server instance. For more information about other parameters for installing the backup client, see Preparations.
  4. On the SQL Server Instance tab, find the SQL Server instance to be restored and click Restore in the Actions column.

What to do next

In the HBR console, you can view the status of restore jobs and cancel ongoing restore jobs. Follow these steps:

  1. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SQL Server.
  2. On the page that appears, click the Restore Jobs tab.
  3. View the status of restore jobs in the Status column.
  4. To cancel an ongoing restore job, find the target job and click Cancel in the Actions column.