TencentDB for SQL Server has rich backup capabilities to guarantee the data security and prevent data loss or corruption. You can manage and view backups on the Backup Management page in the console. Specifically, you can configure automatic backup, manual backup, data backup, log backup, backup file format (unarchived files or archive file), instance backup, multi-database backup, and cross-region backup. You can also customize the backup policy, backup retention period (7–1,830 days), and backup cycle. For more information, see Backup Overview.
TencentDB for SQL Server retains an automatic backup for seven days by default, which can be customized.
The validity period is subject to the configured backup retention period. For more information, see Configuring Automatic Backup. There is no limit on the retention period of manual backups, and you can delete them as needed. For more information, see Deleting Manual Backup.
No. However, you can lower the backup frequency and delete manual backup files no longer used in the TencentDB for SQL Server console to reduce the backup space usage.
Check the automatic backup time you configured. If the instance is performing the daily automatic backup task, you cannot initiate a manual backup task.
Backup tasks in TencentDB for SQL Server cannot be canceled.
A backup window is a custom time period for daily automatic backup, during which the TencentDB for SQL Server instance will be backed up. Based on such regular backups, TencentDB for SQL Server allows you to roll back the instance to a backup point within the retention period. During the backup window, the business won't be affected, but you cannot restart or manually backup the instance in the TencentDB for SQL Server console.
Log in to the TencentDB for SQL Server console, click the ID of the target instance in the instance list, select the Backup Management tab, click Backup Task Settings, and set Upload Backup File to Unarchived files. Then, the .bak file of each database in the instance will be directly uploaded to COS without being archived. For more information, see Setting Backup Task.
Log in to the TencentDB for SQL Server console, click the ID of the target instance in the instance list, select the Backup Management tab, click Backup Task Settings, and set Execute Backup Task to On the replica node. For more information, see Setting Backup Task. You can configure this option only for 2017/2019 Cluster Edition instances.
The TencentDB for SQL Server console provides the list of backup files that can be downloaded over the private or public network.
Log in to the TencentDB for SQL Server console, click the ID of the target instance in the instance list, select the Backup Management tab, and click Download in the Operation column of a backup file in the backup list to get its private/public network download addresses. You can also directly click Download to download the file. For more information, see Downloading Backup.
TencentDB for SQL Server cannot be backed up with third-party tools. For security considerations, third-party tools cannot be granted the permissions of data directories on the physical machine. You can initiate backup tasks only in the console.
Expired backup sets will be automatically deleted and cannot be downloaded or restored.
Manual backups will also take up the backup space. We recommend you plan the usage of the backup space appropriately to reduce costs.
After a TencentDB for SQL Server instance is deleted, all its backup files will be deleted automatically. To retain the data, back up the data first before deleting the instance.
TencentDB for SQL Server offers a certain amount of backup space free of charge by region, which is equivalent to the sum of storage spaces of all Basic Edition, Dual-Server High Availability Edition, and Cluster Edition primary instances in a region. For the pricing of backup space beyond the free tier, see Backup Space Billing.
If the size of backup files exceeds the free tier of the backup space, you can increase the storage space or reduce the backup space usage.
Instance backup files will use the backup space. Each TencentDB for SQL Server instance provides a certain free tier of backup space, and excessive usage will incur additional fees.
The rollback feature relies on the backup cycle and retention period of data backups and log backups, but reducing the frequency and retention period of automatic backups will affect the rollback time range for instance data, you need to configure backup appropriately based on your actual needs.
|Business Scenario||Recommended Backup Retention Period|
|Core businesses||7–1,830 days|
|Non-core, non-data businesses||Seven days|
|Archival businesses||Seven days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use|
|Testing businesses||Seven days. We recommend you manually back up data based on your actual business needs and delete the backups promptly after use|
Log in to the TencentDB for SQL Server console and select Database Backup to view the backup space statistics and trends of all instances in each region under your account as well as the real-time backup space statistics of each instance. For more information, see Viewing Backup Space.
The retention period of TencentDB for SQL Server data backups is seven days by default and can be customized. The retention period of log backups is the same as that of data backups. You can roll back the instance data to any time point within the configured backup retention period. For more information, see Rolling back Database.
TencentDB for SQL Server provides the database cloning feature for you to quickly clone an existing database to your current instance. You need to specify the new database name during cloning, while other information such as account permissions of the new database is the same as that of the source database. For more information, see Cloning Database.
You can use backup files to restore data to other TencentDB or self-built databases at any time. For more information, see Cold Backup Migration.
In the TencentDB for SQL Server console, you can use the cold backup migration feature to restore a database to another TencentDB for SQL Server instance from the downloaded backup file. For more information, see Cold Backup Migration.
In the TencentDB for SQL Server console, you can directly upload the backup file of a self-built database or download it from COS to restore it to TencentDB for SQL Server through the cold backup migration feature. For more information, see Cold Backup Migration.
TencentDB for SQL Server supports full backup. After downloading a backup file, you can restore it to a self-built database as needed. For more information, see Downloading Backup.
Backup files uploaded in backup and restoration scenarios are directly uploaded to COS for relay and don't use your backup space. Once successfully uploaded, they will be retained for only 24 hours and will be deleted automatically after then.