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 as needed. You can restore the database 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

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

Background information

Before you restore an SQL Server database, take note of the following 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 > ECS Database Backup.
  3. On the ECS Database Backup page, click the SQL Server tab.
  4. Select the region where the SQL Server instance that is backed up resides.
  5. On the Database Instance tab, find the MySQL instance. Click Restore in the Actions column.
  6. In the Create Restore Job dialog box, configure the following settings as prompted. Click Next.
    1. Set the parameters for the restoration job.
      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 that is backed up after 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 job.
      • Job Name: the name of the restoration job.
      • Restoration Time: By default, this parameter is set to Right Now. This value indicates that the restoration job is immediately run.
    3. Configure the restoration settings.
      • Target Database: the name of the database that you want to restore to the SQL Server instance.
      • Retry Seconds: the interval between the time when the database is disconnected and the time when the database is reconnected.
      • Speed Limit: the maximum size of data that is restored per second.
    4. Configure the destination database instance.
      Select a destination database instance. Default value: Source Instance.
  7. Click Create.