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.

Note
  • 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 primary database of an SQL Server instance, start the SQL Server instance in single-user mode. For more information, see Restore the master Database (Transact-SQL).
  • 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.

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