You can use Hybrid Backup Recovery (HBR) to back up on-premises SQL Server databases and restore the databases if needed. This topic describes how to back up SQL Server databases.
Prerequisites
Preparations are completed.
Create a backup plan
To create a backup plan for an SQL Server instance, perform the following steps:
What to do next
After a backup plan is created, you can manage the backup plan, cancel backup jobs, and view data backups and log backups.
- Manage a backup plan
In the HBR console, you can view the information and status of created backup plans and manage the backup plans. To manage a backup plan, perform the following steps:
- In the left-side navigation pane, choose SQL Server. . On the On-Premises Backup page, click
- Click the Backup Plans tab.
- On the Backup Plans tab, view the information and status of backup plans.
- Click a button in the Actions column to manage the backup plan if needed. In the Actions column, you can click Modify, Run Immediately, Suspend Plan, Resume Plan, or Delete Plan. If you delete the backup plan, HBR no longer runs backup jobs for the plan but the backup data is retained.
- View or cancel a backup job
You can view the status of backup jobs and cancel running backup jobs. To view or cancel a backup job, perform the following steps:
- In the left-side navigation pane, choose SQL Server. . On the On-Premises Backup page, click
- Click the Backup Jobs tab.
- On the Backup Jobs tab, find the backup job and view its information and status.
- To cancel a running backup job, find the job and click Cancel in the Actions column.
- View data backups and log backups
To view data backups and log backups of an SQL Server instance, perform the following steps:
- Log on to the HBR console.
- In the left-side navigation pane, choose . On the On-Premises Backup page, click SQL Server.
- Click the SQL Server Instances tab.
- On the SQL Server Instances tab, find the SQL Server instance. Click the instance ID in the Hostname/Instance Name column or choose More > View Details in the Actions column. The SQL Server Instances page appears.
- On the SQL Server Instances page, click the Data Backups tab to view data backups or the Log Backups tab to view log backups.