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. You are not charged for using a vault in the first 30 days. You are charged after the free-trial period ends. You can store data from various databases.
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. A free capacity of 100 GB is provided for each backup vault per month. After the free quota is used up, you are charged based on tiered pricing.
NoteYou 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.
Cloud Assistant Agent is installed on the ECS instance that hosts the database.
A Cloud Backup client for ECS must be used together with Cloud Assistant.
If you purchased the ECS instance before December 1, 2017, you must manually install Cloud Assistant Agent. For more information, see Install Cloud Assistant Agent.
If you purchased the ECS instance on or after December 1, 2017, Cloud Assistant Agent is pre-installed.
A backup account is created and the required permissions are configured. For more information, see Step 2: Create a backup account and configure permissions and Step 3: Configure network settings.
The username and password that are used to access the SQL Server database are obtained.
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
Log on to the Cloud Backup console.
In the left-side navigation pane, choose .
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.
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.
NoteAll the databases that are deployed on ECS instances 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 databases deployed on ECS instances.
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).
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. For more information, see Step 2: Create a backup account and configure permissions and Step 3: Configure network settings.
Password
The password of the database instance.
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 in the Actions column of the database.
WarningAfter 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
FAQ
What do I do if the status of an SQL Server database is Inactivated in the console?