All Products
Search
Document Center

Cloud Backup:Register an ECS-hosted SQL Server database

Last Updated:Dec 03, 2024

Before you use Cloud Backup to back up an SQL Server database deployed on an Elastic Compute Service (ECS) instance, you must register the SQL Server database in the Cloud Backup console. When you register an SQL Server database, Cloud Backup installs a client on the ECS instance. Then, you can back up the SQL Server database.

Prerequisites

  • Cloud Backup is activated. You are not charged for activating Cloud Backup. You are charged for using the database backup feature of Cloud Backup based on the following billable items:

    • Rental of database backup vaults. Backup vaults are free of charge for each UID for 30 days. A free capacity of 100 GB is provided for each backup vault per month.

    • Storage usage of database backup vaults. You are charged for the backup storage based on the storage space occupied by the data that is deduplicated and compressed. Backup vaults are free of charge for 30 days. After the free trial period ends, you are charged based on tiered pricing.

      Note

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

    For more information, see Pricing of Cloud Backup.

  • The preparations for using Cloud Backup are complete. For more information, see Before you begin.

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.

    image

  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. image

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.

What to do next

Back up an SQL Server database

FAQ

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