After using 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 or another SQL Server instance that uses the same backup vault.

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.

Create a restore job

To create a restore job, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > On-Premises Backup. On the On-Premises 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. Then, set restore rules as described in the following table.
    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.

  7. Click Next, confirm the preceding settings, and then click Create.

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 > On-Premises Backup. On the On-Premises 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.