You can use Hybrid Backup Recovery (HBR) to back up SQL Server databases deployed on Alibaba Cloud Elastic Compute Service (ECS) instances and restore these databases as required. This topic describes how to back up a SQL Server database.

Prerequisites

Preparations are completed.

Procedure

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose ECS Backup > SQL Server Backup.
  3. In the right-side Actions column, click Backup for the SQL Server instance to be backed up.
  4. In the Create Plan dialog box, select the database to be backed up.
    • If you want to back up an existing database group, click Database Group, and select a database group.
    • If you want to back up a new database group, you need to first create a backup database group. Click Select Database, select databases that you want to back up, and then set Group Name to create a backup database group.
    • If you want to back up all databases, click All Database.
  5. Click Next. On the tab that appears, set the parameters as instructed in the following table.
    Parameter Description
    Backup Type
    • Complete: backs up full data in the database.
    • Differential: backs up data modified after the last full backup.
      Note
      • Before you start the first differential backup for a database, you need to perform a full backup.
      • After you restore a database, to perform a differential backup for the database, you need to perform a full backup first.
    • Log: backs up logs for the database.
      • Before you back up logs for a database for the first time, you need to perform a full backup.
      • After you restore a database, to back up logs for the database, you need to perform a full backup first.
    Plan Name Specify the name of the backup plan.
    Start Time Select the time to start backup. The time is accurate to seconds.
    Plan Interval Select the frequency of backups. The time is accurate to the hour.
    Retention Select the retention period for backup. Minimum retention period: one day. Maximum retention period: five years.
    Note The retention period for differential backup is the same as that for full back, and cannot be modified.
  6. After the configuration is completed, click OK.

Related operations

View and edit a backup plan

In the HBR console, you can view the information and status of created backup plans, and manage these backup plans. The procedure is as follows:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose ECS Backup > SQL Server Backup.
  3. Click the Backup Plan tab.
  4. Check the backup plan information and status on the Backup Plan tab.
  5. Click an operation in the Actions column to manage a backup plan. Operations in the Actions column are Edit, Excute Now, Disable Plan, Enable Plan, and Delete Plan. After you delete a backup plan, HBR does not run the plan any more but reserves backup data.
View and cancel a backup job
You can view the status of backup jobs. You can also cancel an ongoing backup job. The procedure is as follows:
  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose ECS Backup > SQL Server Backup.
  3. Click the Backup Jobs tab.
  4. Check the backup job information and status on the Backup Jobs tab.
  5. To cancel an ongoing backup job, click Cancel in the right-side Actions column for the job.
View the history of database backup and log backup

You can view the history of database backup and log backup. The procedure is as follows:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose ECS Backup > SQL Server Backup.
  3. Click the SQL Server Instance tab.
  4. Find the target SQL Server instance. Click the instance name or ID, or click View Detail for the instance in the right-side Actions column. The SQL Server Instance page appears.
  5. On the SQL Server Instance page, click the Data Backups tab to view database backup records, or the Log Backups tab to view log backup records.