Cloud Backup:Register an on-premises SQL Server database

Procedure

1. Log on to the Cloud Backup console.

2. In the left-side navigation pane, choose Backup > Database Backup. In the top navigation bar, select a region. On the Database Backup page, click the SQL Server tab. On the Local Database Instance tab, click Register Database Instance.

   

3. In the Add Client panel, install and activate a Cloud Backup client as prompted.

   Automatically install the Cloud Backup client for database backup

   1. Download and decompress the Cloud Backup client for Windows.

      Note

      To download the Cloud Backup client to your on-premises server, you can right-click the URL to copy the URL, and then open the URL in a browser on the on-premises server.

   2. Log on to the on-premises server. Go to the decompression directory and enter PowerShell in the path bar to open the terminal window. Then, click the icon in the Cloud Backup console, and copy and run the installation command in PowerShell to activate the Cloud Backup client for Windows.

      

   3. If the content of the red box in the following figure appears, the Cloud Backup client for Windows is installed.

      

   4. If Database Status is displayed as Inactivated, perform the following substeps to activate the database:

      1. Find the database and click Config in the Database Status column.

         

      2. In the Activate Instance dialog box, enter the database username and password you prepared in advance and click OK.

         

4. Optional. If the automatic installation of the Cloud Backup client for Windows fails, perform the following steps to manually install the Cloud Backup client.

   Manually install the Cloud Backup client for database backup

   1. Download and decompress the Cloud Backup client for Windows.

   2. Double-click dbackupxxxxx.dbg.exe of version 42518 and click Next.

      

   3. Select File and Microsoft SQL Server and click Next.

      

   4. Copy the values of the Backup Server IP Address, Backup Server Port, and Access Key parameters from the Cloud Backup console to the corresponding fields in the installation step, and select Secure Sockets Layer (SSL) encryption. Click Next until the installation is complete.

      

   5. When the installation is complete, go to the decompression directory and enter PowerShell in the path bar to open the terminal window. Then, click the icon in the Cloud Backup console to copy and run the installation command in PowerShell.

      

      If the content of the red box in the following figure appears, the Cloud Backup client is installed.

      

   6. Go back to the Cloud Backup console and activate the on-premises database.

      1. Choose More > Reactivate in the Actions column of the database.

      2. In the Activate Instance dialog box, enter your database username and password and click OK.

         

Delete a registered database

1. Log on to the on-premises server and perform the following substeps to uninstall the Cloud Backup client for Windows:

   1. Go to the installation directory of the Cloud Backup client by using PowerShell, for example, C:\Program Files\aliyun\unibackup>.

   2. Run the following command:

       .\uninstall-unibackup.exe /S /NCRC

2. On the Local Database Instance tab, find the database that you want to unregister, and choose More > Unregister Instance in the Actions column.

   Warning

   After you unregister a database, all backups generated by the Cloud Backup client for Windows cannot be restored. Proceed with caution.

3. In the dialog box that appears, click OK.

Related operations

• Unregister Instance

  If you no longer need to back up an SQL Server database, perform the following operations to unregister the database: Click the ECS Database Instance tab. Choose More > Unregister Instance in the Actions column of the database. In the message that appears, click OK

• Unregister a database

  If you no longer need to back up an SQL Server database, perform the following operations to unregister the database: Click the ECS Database Instance tab. Then, choose More > Unregister Instance in the Actions column of the database.

  Warning

  After you unregister a database, all backups generated by the Cloud Backup client for Windows cannot be restored. Proceed with caution.

• Create Cluster

  If your SQL Server database belongs to a cluster, you must create another cluster that consists of the database after you register the database. Cloud Backup backs up all databases in a cluster to the same backup vault. To create a cluster, perform the following operations: On the ECS Database Instance tab, select your database to be added to the cluster. Click Create Cluster. In the dialog box that appears, select the databases that belong to the cluster and click OK.

FAQ

What do I do if the following error message is returned when I install a Cloud Backup client to back up an on-premises SQL Server database: Failed to run install script:exit status 4?