Community Blog How to Configure Alibaba Cloud Hybrid Backup Recovery to Back up ECS SQL Server Databases

How to Configure Alibaba Cloud Hybrid Backup Recovery to Back up ECS SQL Server Databases

This article explains how to configure Alibaba Cloud Hybrid Backup Recovery (HBR) to backup ECS SQL Server databases.

By Kelvin Galabuzi

What Is Alibaba Cloud Hybrid Backup Recovery?

Alibaba Cloud Hybrid Backup Recovery (HBR) is a highly reliable and efficient managed backup service that backs up data to a cloud vault.

HBR can backup data from Elastic Computing Services instances (ECS), Apsara Filesystems, NAS clusters, Object Storage Service (OSS) buckets, files, databases, and virtual machines from on-premises environments.

Hybrid Backup Recovery allows backup and recovery of ECS instances across regions through mirror vaults.

Components of Hybrid Backup Recovery

  • Backup Source: This is the host where the data you want to backup is stored, such as servers, Object Storage Service buckets, NAS clusters, and virtual machines, found on-premises or on ECS instances in Alibaba Cloud.
  • Client: This is the agent you install on the backup source to automate backing up and restoring data.
  • Region: The physical location of an Alibaba Cloud data center.
  • Backup Vault: This is the cloud repository used to backup data on the cloud. An HBR repository supports multiple clients using the same vault and helps manage data backups.

Backup Sources for Hybrid Backup Recovery Service

  • On-Premises Environments: You can backup data from on-premises environments, such as files, NAS, VMware Virtual machines, and databases running on a variety of engines, such as MySQL, Oracle, and Microsoft SQL database.
  • Alibaba Cloud ECS: You can also backup data from files, cloud disks, and databases running on Alibaba Cloud Elastic Computing service instances.
  • Cloud Storage Gateway: Backing up data from storage gateways is supported.
  • Apsara File Storage NAS: You can also backup data stored in Apsara File Storage NAS.
  • Alibaba Cloud Object Storage Service (OSS): Backing up data stored in buckets hosted on the Object Storage Service (OSS) is supported by HBR.

Back up an Alibaba Cloud ECS SQL Server Database using Hybrid Backup Recovery

The following section explains how to back up an ECS SQL Server Database using Hybrid Backup Recovery.

  • Step 1: Log in to the Alibaba Cloud console and access Hybrid Backup Recovery under the Storage Data Services category:


  • Step 2: Navigate to the Backup database blade and select SQL Server:


  • Step 3: Click Register Database Instance:


  • Step 4: Select the server by hostname and click Next:


  • Step 5: Insert the database account username and password and click OK:


  • Step 6: Click OK when the dialogue box prompts to install the backup client opens:


  • Step 7: After installing the client automatically, the database instance will present its status as Online:


  • Step 8: If you want to backup any database on the SQL Server instance, click Back Up:


  • Step 9: On the Backup plan, select the database you want to backup and click Next:


  • Step 10: Configure the Backup plan settings and click Next:


  • Step 11: Set up the Backup config settings and click Next:


  • Step 12: Create or select the target backup vault, enter the Vault Name, set the Retention Period, and click OK:


  • Step 13: Finally, you will have access to the console where you can manage your backups:


0 0 0
Share on

Alibaba Cloud Community

827 posts | 185 followers

You may also like