Cloud Backup:Register SQL Server (ECS)

Usage notes

• If you only register a SQL Server database in the console without creating a backup plan, Cloud Backup does not charge any fees.

• Limitations apply to supported database versions, operating systems, and backup features. For more information, see Compatibility list and limitations.

• Ensure that the ECS instance has .NET Framework 4.5 or later installed.

• SQL Server does not support database files on a compressed file system. For more information about database installation limitations, see File Locations for Default and Named Instances of SQL Server.

• When a SQL Server database is configured in the simple recovery model (the default), Log Backup is not supported. Use Full Backup or Cumulative Incremental Backup.

• The master database in SQL Server supports only Full Backup, not Cumulative Incremental Backup or Log Backup.

Procedure

1. Log on to the Cloud Backup console.

2. Click Backup > Database Backup, select a region, and then click SQL Server. On the ECS Database Instance tab, click Register Database Instance.

3. In the Register SQL Server Instance panel, select the target database, and click Next.

   Note

   • The system automatically loads all ECS database resources in the current region. If you cannot find a database instance, you can click Discover Database, and Cloud Assistant will automatically scan for and discover database instances on your ECS instances.

   • For information about supported database versions and backup features, see Supported database versions and backup features.

4. On the Config Link Info tab, configure the parameters as described in the following table and click OK.

   Parameter	Description
   Database Account	This is the username for the database instance. Although you can use the system administrator account, we recommend creating a dedicated backup account. The minimum required permissions for this user are: Server roles: sysadmin and dbcreator. Database roles: db_backupoperator and db_owner. For more information, see Step 2: Create a backup account and configure permissions.
   Password	The password for the specified user.

   After the instance is registered, an ECS backup client is installed on the nodes of the SQL Server instance. You can view the installation status of the backup client for the nodes on the ECS Database Instance tab. Then, upgrade the ECS backup client based on your business requirements. The status of the SQL Server database instance is Online. After the configuration is complete, confirm that the Client Status is displayed as Installed and the Database Status is displayed as Online in the backup management list.

More operations

• Unregister Instance

  When you no longer need to back up a SQL Server database instance, on the ECS Database Instance tab, find the target instance, and in the Actions column, select ⋮ > Unregister Instance. In the dialog box that appears, click Confirmation.

  Warning

  When you unregister an instance, all its backup data becomes permanently unrecoverable. This action cannot be undone. Proceed with caution.

• Create Cluster

  If your SQL Server database instances belong to a cluster, you must manually create a cluster after you register the instances. Cloud Backup backs up these database instances as a single cluster to the same backup vault. On the ECS Database Instance tab, select the database instances that you want to add to the cluster and click Create Cluster. In the dialog box that appears, select the database instances for the cluster and click OK to create the cluster.

  Note

  After you create an SQL Server Always On availability group, you need to configure a backup plan for only one database instance in the group.

FAQ

• How do I view the default installation path and logs of the Cloud Backup client?

• FAQ about database backup