Cloud Backup:Register an ECS-hosted SQL Server database

Usage notes

• You are not charged for using Cloud Backup if you only register an SQL Server database in the Cloud Backup console.

• Cloud Backup supports a limited number of database versions, operating systems, and backup features. For more information, see the "Supported database versions" section in Overview (ECS-hosted databases).

• You must make sure that .NET Framework 4.5 or later is installed on the ECS instance.

• If the compression feature is enabled for a file system, the files of an SQL Server database cannot be stored in the file system. For more information, see File Locations for Default and Named Instances of SQL Server.

• If an SQL Server database uses the simple recovery mode, Log Backup is not supported. You can select Full Backup or Cumulative Incremental Backup.

• If you are using a master database, Cumulative Incremental Backup and Log Backup are not supported. You can select only Full Backup.

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 ECS Database Instance tab, click Register Database Instance.

   

3. On the Select Database Instance tab in the Register SQL Server database instance panel, select the database that you want to register and click Next.

   Note

   • All the ECS-hosted databases in the current region are displayed. If you cannot find the database that you want to register, you can click Discover Database. Cloud Assistant automatically scans all databases and discovers the ECS-hosted databases.

   • Limits are imposed on the supported database versions and backup features. For more information, see the "Supported database versions" section in Overview (ECS-hosted databases).

4. In the Config Link Info step, configure the parameters and click OK. The following table describes the parameters.

   Parameter	Description
   Database Account	The username of the database instance. You can use the system administrator account. We recommend that you create a dedicated backup account. The following part lists the minimum permission set of the user: 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 user password.

   After you register the SQL Server database, Cloud Backup installs a client for ECS backup on each node of the SQL Server database. On the ECS Database Instance tab, you can view the installation status of the Cloud Backup client on each node of the SQL Server database. You can also upgrade a Cloud Backup client based on your business requirements. The SQL Server database is in the Online state.

Related operations

• View logs

  Log on to the ECS instance and view the log of the Cloud Backup client in the C:\ProgramData\scutech\dbackup3\agent\log\dbackup3-agent.log path.

• 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 a 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. Click Create Cluster, select the databases that belong to the cluster, and then click OK.

FAQ

What do I do if the status of an SQL Server database is Inactivated in the console?