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 SQL Server databases.
Prerequisites
Preparations are completed.
Background
Before you back up SQL Server databases, note the following points:
- Make sure that .NET Framework 4.5 or later is installed.
- HBR supports the following SQL Server versions: SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, and SQL Server 2017. For more information, see Limits.
- SQL Server databases cannot be installed in a file system where compression is enabled. For more information about limits on SQL Server installation, see File Locations for Default and Named Instances of SQL Server.
Create a backup plan
To create a backup plan, follow these steps:
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 manage these backup plans. To view and manage a backup plan, follow these steps:
- In the left-side navigation pane, choose SQL Server. . On the ECS Application Backup page, select
- On the page that appears, click the Backup Plan tab.
- On the Backup Plan tab, find the target backup plan and check its information and status.
- 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:
- In the left-side navigation pane, choose SQL Server. . On the ECS Application Backup page, select
- On the page that appears, click the Backup Jobs tab.
- On the Backup Jobs tab, find the target backup job and check its information and status.
- To cancel an ongoing backup job, find the target job and click Cancel in the Actions column.
- 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:
- In the left-side navigation pane, choose SQL Server. . On the ECS Application Backup page, select
- On the page that appears, click the SQL Server Instance tab.
- On the SQL Server Instance tab, find the target SQL Server instance. Click the instance name or ID, or choose View Details in the Actions column. >
- 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.