tencent cloud

All product documents
TencentDB for SQL Server
DocumentationTencentDB for SQL ServerOperation GuideBackup and Restoration BackupSetting Automatic BackupSetting Non-Archive Backup Retention
Setting Non-Archive Backup Retention
Download PDF
Last updated: 2024-01-18 17:23:30
Setting Non-Archive Backup Retention
Last updated: 2024-01-18 17:23:30
Download PDF
TencentDB for SQL Server supports automatic backup (including non-archive backup and archive backup) and manual backup. This document describes how to configure non-archive backup retention in the console.
Note:
The TencentDB for SQL Server instance only backs up data from the business databases rather than the system databases.
The backup is stored in the Beijing time zone (UTC+8) by default. If the default time zone is modified, it will be stored in the time zone of the instance server, but its storage time will still be in Beijing time in the console.

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 Notes, and click Save.


Parameter
Description
Start Time
You can set a start time as needed. We recommend that you set it to a value during off-peak hours. This is just the start time of the backup process and does not indicate the end time.
For example, if the time range is set to 01:00–02:00 AM, the system will initiate a backup at a time point during 01:00–02:00 AM, which depends on the backend backup policy and backup system conditions.
Data Backup Retention Period
It is 7 days by default and can be any value between 7 and 1,830 days. Backup sets will be automatically deleted upon expiration.
Backup Cycle
You can select any time between Monday and Sunday 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.
Periodic Archive
The Periodic Archive switch is toggled off when you set non-archive backup retention.
Log Backup Retention Period
It is the same as the data backup retention period by default and cannot be changed. That is, if the data backup retention period is set to 30 days, the log backup retention period will also be 30 days. Backup sets will be automatically deleted upon expiration.
Log Backup Frequency
Backup is performed once every 10 minutes by default.

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Contact Us
Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

Submit a Ticket
7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon