You can use Hybrid Backup Recovery (HBR) to back up SQL Server databases deployed on Elastic Compute Service (ECS) instances. You can also restore the databases based on your business requirements. This topic describes how to back up an SQL Server database.

Background information

  • You must install .NET Framework 4.5 or later version in advance.
  • Some versions of SQL Server databases cannot be backed up by using HBR. For more information, see Overview.
  • The files of an SQL Server database cannot be stored in a file system whose compression feature is enabled. For more information, see File Locations for Default and Named Instances of SQL Server.
  • If an SQL Server database uses the simple recovery mode, Log Backup is not supported. You can select only Full Backup or Cumulative Incremental Backup.
  • If you are using a master database, Cumulative Incremental Backup and Log Backup are not supported. You can select only Full Backup.

Create a backup plan

After you register an SQL Server instance, you must create a backup plan in the HBR console to back up the instance. To create a backup plan, 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 Back Up in the Actions column.
  7. In the Create Backup Plan panel, perform the following steps:
    1. Set the backup parameters and click Next.
      1. Specify Plan Name.
      2. Select the SQL server instance that you need to back up.
    2. Configure the backup plan and click Next.
      Parameter Description
      Recommended Plan The recommended backup plan. Default value: Typical Plan.
      • Typical Plan: enables the Full Backup and Cumulative Incremental Backup features.
      • Critical Application: enables the Full Backup, Cumulative Incremental Backup, and Log Backup features.
      • Customize: enables a custom backup policy.
      Full Backup If you select Full Backup, all the database files in the operating system are backed up.

      However, you can restore the files to only the points in time at which the files are backed up.

      You can back up files immediately or at a specified point in time. You can also schedule periodic backups by hour, day, week, or month. A custom backup plan is supported.

      Cumulative Incremental Backup If you select Cumulative Incremental Backup, incremental database files in the operating system are backed up.

      However, you can restore the files to only the points in time at which the files are backed up.

      You can back up files immediately or at a specified point in time. You can also schedule periodic backups by hour, day, week, or month. A custom backup plan is supported.

      Log Backup If you select Log Backup, database logs are backed up. You can restore the logs to a specific point in time.

      You can back up database logs immediately or at the specified time. You can also schedule periodic backup by hour, day, week, or month. A custom backup plan is supported.

    3. Configure the backup settings and click Next.
      You can specify the number of concurrent threads, the retry time, and the limit of the backup speed.
      Parameter Description
      Concurrent Threads The number of concurrent threads when files are being backed up.
      Retry Time The time interval between two consecutive reconnection attempts if the database is disconnected during backup. Unit: minutes.
      Speed Limit The maximum size of data that is backed up per second. Unit: MB/s.
    4. Select a backup vault and click OK.
      If you perform a backup for the first time, you must first create a backup vault. Click Create Vault and specify the Vault Name parameter and other parameters as prompted.
      Notice You can back up an instance to only one backup vault.

What to do next

On the Backup Plan tab, find the backup plan. In the Actions column, you can click buttons to perform the following operations:

  • Edit a backup plan

    If a backup plan cannot meet your requirements, you can click Edit to modify the backup plan.

  • Configure alerts

    You can choose More > Alert Settings in the Action columns and then select a backup alert policy. The following table describes the alert policies.

    Alert policy Description
    Disabled The backup client does not send alert notifications.
    Same as Vault The backup client sends alert notifications in the same way as the backup vault.
    Default The backup client sends alert notifications to the owner of the Alibaba Cloud account by using emails.
    Custom If you select this option, you must select one or more contacts or contact groups. Then, the backup client sends alert notifications to the selected contacts and contact groups.
  • Delete backup plans

    If you delete a backup plan, all backup and restoration jobs that are being performed by the client fail.

    You can choose More > Delete Backup in the Actions column and then click OK to delete the backup data that is no longer required.

What to do next

Restore an SQL Server database