Back up SQL Server databases

Prerequisites

Preparations are completed.

Create a backup plan

To create a backup plan, follow these steps:

1. Log on to the HBR console.
2. In the left-side navigation pane, choose Backup > On-Premises Backup. On the On-Premises Backup page, select SQL Server.
3. On the page that appears, click the SQL Server Instance tab. On the SQL Server Instance tab, find the target SQL Server instance and click Backup in the Actions column.
4. In the Create Plan pane that appears, select the databases to be backed up.
   • If you have added the databases to be backed up to a database group, set Select Backup Source to Database Group and select the database group.
   • If you have not added the databases to be backed up to a database group, set Select Backup Source to Select Database. Select the databases to be backed up and set Group Name to create a database group. For more information, see Create a database group to be backed up.
   • If you want to back up all databases, set Select Backup Source to All Database.
5. Click Next. In the Config Backup Plan step, set the parameters as described 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 must perform a full backup. After you restore a database, to perform a differential backup for the database, you must 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 must perform a full backup. After you restore a database, to back up logs for the database, you must perform a full backup first.
   Plan Name	The name of the backup plan.
   Start Time	The start time of the backup plan. The time is accurate to seconds.
   Plan Run Interval	The interval for backing up data. Valid units: hours, days, and weeks. Note The retention period of incremental backup data is the same as that of full backup data and cannot be changed.
   Retention	The retention period of backup data. Minimum retention period: 1 day. Maximum retention period: 5 years.

6. After the configuration is completed, click OK.

What to do next

After a backup plan is created, you can view and manage the backup plan, cancel backup jobs, and view the records of database backups and log backups.

• View and manage a backup plan

  In the HBR console, you can view the information and status of created backup plans, and modify and manage these backup plans. To view and manage a backup plan, follow these steps:

  1. In the left-side navigation pane, choose Backup > On-Premises Backup. On the On-Premises Backup page, select SQL Server.
  2. On the page that appears, click the Backup Plan tab.
  3. On the Backup Plan tab, find the target backup plan and check its information and status.
  4. Click a button in the Actions column as needed to manage the backup plan. In the Actions column, you can click Edit, Execute, Disable Plan, Enable Plan, or Delete Plan. After you delete a backup plan, HBR no longer runs the plan but retains data that is backed up by using the plan.
• View or cancel a backup job

  In the HBR console, you can view the status of backup jobs or cancel ongoing backup jobs. To view or cancel a backup job, follow these steps:

  1. In the left-side navigation pane, choose Backup > On-Premises Backup. On the On-Premises Backup page, select SQL Server.
  2. On the page that appears, click the Backup Jobs tab.
  3. On the Backup Jobs tab, find the target backup job and check its information and status.
  4. To cancel an ongoing backup job, click Cancel in the Actions column for the backup job.
• View the records of database backups and log backups

  You can view all backup records in the HBR console. To view backup records, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > On-Premises Backup. On the On-Premises 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 target SQL Server instance. Click the instance name or ID, or choose More > View Details in the 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.