After you use Hybrid Backup Recovery (HBR) to back up an SQL Server database to a backup vault, you can restore the SQL Server database based on your business requirements. You can restore the database to the original SQL Server instance or another SQL Server instance that uses the same backup vault.

Prerequisites

An SQL Server database is backed up. For more information, see Back up an SQL Server database.

Background information

  • You cannot restore an SQL Server database to a specific point in time if you do not back up the database logs.
  • If you restore an SQL Server database that is backed up on an incremental basis, HBR automatically restores all the backup data. You do not need to perform a full backup before you perform an incremental backup.
  • To restore a database of an SQL Server instance to another SQL Server instance, you must check the version of the source SQL Server instance. This version cannot be later than that of the destination SQL Server instance.
  • Before you restore a master database, HBR restarts the SQL Server instance in single-user mode.

Create a restoration job

To create a restoration job, perform the following steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > Database Backup.
  3. In the top navigation bar, select a region.
  4. On the Database Backup page, click the SQL Server tab.
  5. Click the ECS Database Instance or Local Database Instance tab.
  6. On the page that appears, click the SQL Server Instance tab. On the SQL Server Instance tab, find the SQL Server instance and click Restore in the Actions column.
  7. In the Create Restore Job panel, configure the following settings as prompted.
    1. Set the restoration parameters and click Next.
      Parameter Description
      Restorable Databases From the drop-down list, select the database that you want to restore.
      Restoration Method Specify a method to restore the database.
      • If you want to restore data to a specific point in time, set this parameter to Specified Start Time.
      • If you want to restore specified database files, set this parameter to Specified Files. In the Backup list, select the backup files or logs that you want to restore.
    2. Configure the restoration plan and click Next.
      Parameter Description
      Plan Name The name of the scheduled restoration job.
      Restore Time Run Now. This value indicates that the restoration job is immediately run.
    3. Configure the restoration settings and click Next.
      Parameter Description
      Restore to Database The name of the database that you want to restore.
      Retry Time The time interval between two consecutive reconnection attempts if the database is disconnected during restoration. Unit: minutes.
      Speed Limit The maximum size of data that is restored per second. Unit: MB/s.
    4. Configure the restoration settings and click Create.
      Select a database instance. By default, the most recent backed up SQL Server instance is selected.
    After you create a restoration job, the job automatically starts. On the Backup Plan tab, you can view the status of the restoration job.