tencent cloud

TencentDB for SQL Server supports automatic backup and manual backup.
This document describes how to configure automatic backup in the console.

Note：

• Backup files are stored in a separate backup space and do not occupy the local disk space of the instance.
• Do not perform DDL operations during the backup process to avoid backup failure caused by table locking.
• Back up your data during off-peak hours.
• Backup may take a long time if the data volume is large.

Notes on backup

• Increasing the retention period of data and log backups may cause additional backup space fees.
• Shortening the retention period of log backups may affect the data rollback cycle of the instance.
• The free tier for backups is limited, and any excess will be billed on a pay-as-you-go basis.
• Local backups are included in the free tier, while cross-region backups are not, that is, cross-region backups incur fees.

Directions

1. Log in to the TencentDB for SQL Server console.
2. Select the region at the top, find the target instance, and click the target instance ID or Manage in the Operation column to enter the instance management page.
   
3. On the instance management page, select Backup Management and click Auto-Backup Settings.
4. In the pop-up window, set the following configuration items, read and select Backup Space Billing Description, and click Save.
   • Start Time: It is customizable and recommended to be within off-peak hours.
     For example, if the time range is set to 01:00–02:00, the system will initiate a backup at a time point during 01:00–02:00, which depends on the backend backup policy and backup system conditions.
   • Data Backup Retention Period: It is 7 days by default and customizable between 7 and 1,830 days. Backup sets will be automatically deleted upon expiration.
   • Backup Cycle: Any time between Monday and Sunday can be selected for backup.

     Note：

     To ensure the continuity between the data backup retention period and backup cycle:

     • If the backup retention period is set to a value smaller than seven days, the backup cycle will be daily, with Monday through Sunday being selected by default.
     • If the backup retention period is set to a value equal to or greater than seven days, at least two backups will be required every week. If you select only one, you cannot click Save.

   • Next Time: Set the time when the configured backup cycle will start.
   • Log Backup Retention Period: It is the same as the data backup retention period by default and cannot be changed. Expired backup sets will be automatically deleted.
   • Log Backup Frequency: Backup is performed once every 10 minutes by default.