Configure Regular Backups
Last updated:2026-01-27 16:16:42
TencentDB for SQL Server supports two methods for database backup: automatic backup and manual backup. For automatic backups, data backups are classified into two scenarios based on different backup retention policies: setting regular backup retention and setting periodic backup retention. The retention period for log backups in automatic backups remains consistent with that of regular data backups.
This article introduces you to how to set regular backup retention via the console.
Note:
TencentDB for SQL Server instance backup only backs up user databases and does not back up system databases.
The backup time defaults to Beijing time. If the default time zone is modified, the storage time of backup data will be displayed in the time zone of the instance server, but the console display will be in Beijing (UTC+8) time.
Automatic Backup Notes
Backup files are stored in an independent backup space and will not occupy the local disk space of the instance.
Do not perform DDL operations during backup to avoid table locking resulting in backup failure.
It is recommended to perform backups during off-peak hours.
If the amount of data is large, the process may take longer. Please be patient.
Automatic Backup Notes
Increasing the retention period for data backups and log backups may result in additional backup storage billing costs.
Reducing the retention period for log backups may affect the data rollback cycle of the instance.
The free backup allowance is limited. If the free allowance is exceeded, the excess portion will be charged on a pay-as-you-go basis.
Local backups occupy the free storage allowance, while cross-region backups do not occupy the free storage allowance; that is, creating cross-region backups will incur billing costs.
Operation Steps
1. Log in to the SQL Server console.
2. Select a region above, locate the target instance, click Instance ID or Manage in the Operation column to go to the instance management page.
3. On the instance management page, select the Backup Management tab and click Auto Backup Settings.
4. In the pop-up dialog box, complete the settings for data backup and log backup, read and select the Backup Storage Billing Notes, and click OK.
Data Backup: The configuration items for data backup are set as follows.
Parameter | Description |
Backup Start Time | Select a time period for backup initiation, preferably during off-peak hours. The backup start time indicates when the backup process begins, not when it ends. For example, if you select 00:00 - 01:00, the system will initiate a backup at a specific time point within this window. The exact initiation time depends on the backend backup policy and the backup system's status. Available time slots are as displayed on the console, such as 00:00 - 01:00, 01:00 - 02:00, and so on. |
Data Backup Retention Period | The default retention period is 7 days. You can customize the retention period (3-7300 days). Backups will be automatically deleted upon expiration. Note: You cannot roll back to a time point outside the retention period. Therefore, set the data backup retention period based on your actual business needs. |
Backup Cycle | Supports selecting any time from Monday to Sunday for performing backups. Note: To ensure that users' data backup retention time and backup cycle remain continuously available: If the backup retention days are set to less than 7 days, the backup cycle will default to daily backups, and all days from Monday to Sunday will be selected by default. If the backup retention days are set to 7 or more, backups must be performed at least twice a week. If only one backup is selected, the settings cannot be completed. |
Estimated Next Backup Time | Displays the next backup time for the current instance. The console shows the time in Beijing (UTC+8). |
Scheduled Backup Retention | When regular backup retention is set, this option remains disabled. |
Log backup: The configuration items for log backup are set as follows.
Parameter | Description |
Log Backup Retention Period | By default, it is consistent with the data backup retention period. Range: 3 - 7300 days. Backup sets are automatically deleted upon expiration. |
Log Backup Frequency | The default is 10 minutes. Range: 10 minutes - 60 minutes. It is recommended to set it to 10 minutes. The higher the frequency, the lower the risk. |
Related APIs
API | Description |
This API (ModifyBackupStrategy) is used to modify backup policies. | |
This API (DescribeBackupByFlowId) is used to query the details of created backups by the ID of the backup creation process, which can be obtained from the CreateBackup API. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback