You can restore SQL Server databases backed up in Hybrid Backup Recovery (HBR) to the source SQL Server instance. You can also restore the databases of other SQL Server instances in the same vault to the current SQL Server instance as required.

Note If you need to restore a database from one instance to another, make sure that the version of the source SQL Server instance is the same as or earlier than that of the destination SQL Server instance.

Procedure

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose On-Premises Backup > SQL Server Backup.
  3. Click the SQL Server Instance tab.
  4. Find the SQL Server instance to which the database is restored and click Restore in the Actions column for the instance.
  5. In the New Restore Task dialog box that appears, select the SQL Server instance from which you want to restore the database and click Next.
  6. Select the database to be restored, click Next, and configure the restore rule. The following table describes the parameters of the restore rule.
    Parameter Description
    Destination Name The name of the database after it is restored to the destination SQL Server instance.
    Note
    • If you want the restored database to overwrite an existing database, enter the name of the existing database, and select Override existing database.
    • If you do not want to overwrite an existing database, enter a name that has not been used by any existing databases.
    Restore Policy
    • Most Recent

      Restores the database to the latest available status that is backed up.

    • Time Point

      Restores the database to the specified time point. The system restores the database to the status closest to this time point. After this option is selected, you also need to select a time point.

    • From Snapshot

      Restores the database to the specified snapshot. After this option is selected, you also need to select a snapshot.

  7. Click Next, confirm the configuration, and then click Create.

View and cancel backup jobs

You can view the status of restore jobs and cancel ongoing restore jobs. The procedure is as follows:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose On-Premises Backup > SQL Server Backup.
  3. Click the Restore Jobs tab.
  4. View the status of restore jobs in the restore job list.
  5. To cancel an ongoing restore job, click Cancel in the Actions column for the restore job.