Before you use Hybrid Backup Recovery (HBR) to back up SQL Server databases deployed on Elastic Compute Service (ECS) instances, you must register an SQL Server instance in the HBR console.

Background information

When you register an SQL Server instance, you must configure the connection information about the SQL Server instance. After the SQL Server instance is registered, an ECS backup client is installed on each node of the SQL Server instance.

After an SQL Server instance is registered, you can view the installation status of the ECS backup client on each node of the SQL Server instance. Make sure that an ECS backup client is installed on all nodes to be backed up. You can also upgrade, uninstall, or delete an ECS backup client based on your business needs.

Register an SQL Server instance

To register an SQL Server instance, follow these steps:

  1. Log on to the HBR console.
  2. In the left-side navigation pane, choose Backup > ECS Application Backup. On the ECS Application Backup page, select SQL Server.
  3. Select the region where the SQL Server instance to be backed up resides.
  4. On the page that appears, click Register SQL Server Instance in the upper-right corner.
  5. In the Register SQL Server Instance pane that appears, set the parameters as described in the following table.
    Parameter Description
    Backup Vault Config Specifies whether to create a backup vault or select an existing backup vault. A backup vault is a repository used by HBR to store backup data in the cloud. You can back up data from multiple backup clients to the same vault. Backup vaults reside in different regions. You can only select or create backup vaults in the current region.
    • If you have created backup vaults, set the value to Select Vault and select a backup vault from the Vault Name drop-down list.
    • If you have not created any backup vaults, set the value to Create Vault and set Vault Name to create a backup vault. The vault name can be a maximum of 64 characters in length.
    Server Name The server name and instance name of the SQL Server instance, in the format of Server name\Instance name. For example, you can enter localhost\MSSQLSERVER. You do not need to enter the instance name for a default instance.
    Note You can replace the server name with the server IP address.
    Authentication The authentication method used to connect to the SQL Server instance.
    Windows Login Name If you select Windows Login for Authentication, enter the username used to log on to the SQL Server instance in Windows in the Windows Login Name field.
    SQL Server User If you select SQL Server Login for Authentication, enter the username used to log on to the SQL Server instance in the SQL Server User field.
    Password The password used to log on to the SQL Server instance. Set the password based on the selected authentication method.
  6. Click Next.
  7. In the Install Backup Agent step, select Use or Not Use for Transmit Data On HTTPS. Select all ECS instances where the SQL Server instance is deployed. Then, HBR can install an ECS backup client on these ECS instances. In the drop-down list on the left of the search bar, select Instance ID or Instance Name. Then, enter an ID, a name, or a keyword in the search bar to search for the desired ECS instances.
    Note
    • Your data will be encrypted and stored in a backup vault. You can choose whether to use HTTPS to encrypt the data during transmission. Note that using HTTPS will degrade the data transmission performance. If you modify Transmit Data On HTTPS, the modification takes effect when the next backup or restore job starts.
    • If you select an ECS instance whose network type is classic network, you must enter the AccessKey ID and AccessKey secret for the selected ECS instance. For more information, see Create an AccessKey for a RAM user.
  8. Click Create. HBR automatically installs an ECS backup client on the selected ECS instances.
    After the SQL Server instance is registered, you can click the SQL Server Instance tab on the ECS Application Backup page to view the registration information and status of the registered SQL Server instance. You can also choose More > Edit Instance in the Actions column to modify the instance information.

View and manage backup clients

After the SQL Server instance is registered, you can view the installation status of the ECS backup client on each node of the SQL Server instance, upgrade or delete a backup client, and view the database information of the target SQL Server instance.

  • View the installation status of an ECS backup client
    To view the installation status of an ECS backup client, follow these steps:
    1. Go to the SQL Server Instance tab.
    2. 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.
    3. On the SQL Server Instance page, click the Client tab. On this tab, find the target ECS instance and view the installation status of the ECS backup client. If the ECS backup client is installed, the client status is Activated. You can also perform other operations as described in the following table.
      Operation Description
      Reinstall an ECS backup client If the ECS backup client fails to be installed, choose More > Install Client in the Actions column.
      Uninstall an ECS backup client To uninstall the ECS backup client, choose More > Uninstall Client in the Actions column.
      Delete an ECS backup client To delete the ECS backup client and remove the target ECS instance, choose More > Delete in the Actions column.
      Note After you delete an ECS backup client, the existing backup data is also deleted, and relevant in-progress backup and restore jobs will fail. Before you delete an ECS backup client, make sure that the backup data of this client is no longer needed and this client has no backup and restore jobs in progress.
  • View databases
    You can view the databases of an SQL Server instance. To view databases, follow these steps:
    1. 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.
    2. On the SQL Server Instance page, click the Database tab. On this tab, you can view the database information of the target SQL Server instance.