Viewing the Backup List

Last updated:2026-01-27 16:16:43

Viewing the Backup List

Last updated: 2026-01-27 16:16:43

TencentDB for SQL Server automatically backs up data according to default backup settings. You can modify automatic backup settings or perform manual backups for instances via the console. Instance-level backup files and related information can be viewed in the instance backup list. This document describes how to view backup lists in the console.
Backup List Tool Item
﻿
Tool
Description
Time Frame
Click 
﻿
 to select the time range for the backup files to be queried. It supports quick selection of last 24 hours, last 7 days, last 15 days, last 30 days, and also supports custom time range (within any 30-day period when backups are generated), with the time range specifiable down to the second.
Search box
Data Backup: Within 
﻿
, you can select resource attributes to filter out the backups to be queried. Resource attributes include Backup ID, Backup Name, Database Name, Backup Method, Backup File Format, Backup Object, Backup Status.
Log Backup: Within 
﻿
, you can select resource attributes to filter out the backups to be queried. Resource attributes include Backup ID, Backup File Format, Backup Status.
Note:
Multiple resource attributes should be separated by the Enter key.
In resource attributes, Backup Name and Database Name support fuzzy matching, while Backup ID does not support fuzzy matching; other resource attributes are option-based settings.
Refreshing
Click 
﻿
 to refresh the list.
Settings
Click 
﻿
 to customize the fields displayed in the list. You can select or deselect fields to configure the display, and drag fields to reorder their sequence in the list. The three fields - Backup ID, Filename/Backup Name, and Operation - cannot be deselected by default and their order cannot be adjusted.
Download
Click 
﻿
 to export the current page data of the list locally.
Operation Steps
1. Log in to the SQL Server console.
2. Select a region at the top, locate the target instance, and click the instance ID or Operation > Manage to go to the Instance Management page.
﻿
3. On the Instance Management page, select Backup Management, then click Data Backup or Log Backup to view detailed information for each data backup or log backup respectively.
Data backup list
﻿
Data Backup List Fields
Description
Backup ID
Backup Set Unique ID.
File Name/Backup Name
The filename and backup name for data backups. For automatic backups, the system automatically generates default filenames and backup names. For manual backups, if no backup name is specified, the system also generates a default name. The backup name can be modified.
﻿
Start/End Time
The start time and end time of the backup.
Note:
The time displayed here is Beijing Time.
Backup Size
The size of the backup files can be sorted.
Backup Duration
Displays the duration consumed by the backup and supports sorting.
Backup Object
The options for this field include: All, Instance Backup, Multi-Database Backup, and can be filtered.
Backup Mode
The options for this field include: All, Automatic - regular, Automatic - scheduled, Manual, and support filtering.
Upload Backup File
Backup file format. The options for this field include: All, Unarchived files, Archive file, and support filtering.
Backup Type
The backup type is physical - full backup.
Backup Region
The region where the backup is stored. This field displays the region corresponding to the backup.
Backup Status
The options for this field include: All, Successful, Failed, Backing up, Waiting, and support filtering, with statuses displayed per region.
Backup Progress
Database backup progress percentage.
Expiration Time
This field displays the expiration time of corresponding backups and supports sorting.
Operation
Download: When the backup file is in the form of archived backup files, the operation column will directly display the download button.
View Details: When the backup file is in the form of single-database backup files, the operation column will display View Details. Click View Details, and you can view the backup information of the specific database in the pop-up window. Click Download to download the backup of the corresponding database.
Rollback: Click Rollback, and you will be redirected to the rollback operation page.
More > Convert into Scheduled: If the instance has enabled regular backup retention, you can use Convert into Scheduled to retain conventional backups generated by automatic backups as regular backups.
More > Delete: Manual backups support saving storage space through the delete operation.
Log backup list
﻿
Field of the Log Backup List
Description
Backup ID
Backup unique ID.
File Name
The name of the log backup file. It is generated by the system by default and cannot be modified.
Start/End Time
The start time and end time of the backup.
Note:
The time displayed here is Beijing Time.
Backup Duration
Displays the duration consumed by the backup and supports sorting.
Backup Size
The size of the backup files can be sorted.
Upload Backup File
Backup file format. The options for this field include: All, Unarchived files, Archive file, and support filtering.
Backup Region
The region where the backup is stored. This field displays the region corresponding to the backup.
Backup Status
The options for this field include: All, Successful, Failed, Backup in progress, Pending, and support filtering, with statuses displayed per region.
Expiration Time
This field displays the expiration time of corresponding backups and supports sorting.
Operation
Download: When the backup file is in the form of archived backup files, the operation column will directly display the download button.
View Details: When the backup file is in the form of single-database backup files, the operation column will display View Details. Click View Details, and you can view the backup information of the specific database in the pop-up window. Click Download to download the backup of the corresponding database.
FAQs
1. Can Backups Beyond the Retention Period Still Be Downloaded or Restored?
Backup sets will be automatically deleted upon expiration and cannot be downloaded or restored.
It is recommended that you reasonably configure the backup retention period based on your requirements or download backup files to your local device via the SQL Server console.
You can also manually back up instance data via the console.
Note:
Manual backups also occupy backup space. Please use the backup space reasonably to avoid incurring additional costs.
2. Backups Can Be Deleted Manually
Automatic backups cannot be manually deleted. You can set the backup retention period, and they will be automatically deleted upon expiration. If you enable the cross-region backup feature, cross-region backup files can also set the cross-region backup retention period, and they will be automatically deleted upon expiration.
Manual backups can be manually deleted in the backup list of the SQL Server console. Unless manually deleted, their retention duration is determined by the retention period policy selected during manual backup.
3. Can Data and Log Backup Be Disabled?
Cannot be disabled. However, you can reduce the backup frequency and delete unused manual backup data via the SQL Server console to decrease backup space usage.
4. How to Reduce Backup Space Overhead?
You can delete unused manual backup data (manual backups can be deleted on the Backup Management page under the Instance Management page of the SQL Server console). 
Reduce the frequency of automatic backups for non-core businesses (you can adjust the backup cycle and retention period in the console, with backups performed at least twice a week).
Note:
Point-in-time restore feature relies on data backups + log backups within the backup cycle and retention period. Shortening the automatic backup frequency and retention period will affect the available time range for instance data restoration. Please balance your backup configuration accordingly.
You can shorten the retention period for data backups and log backups of non-core businesses (a backup retention period of 7 days is sufficient for most scenarios).
Workload Scenario
Backup Retention Period
Core businesses
Recommended 7 days - 7300 days.
Non-core and non-data businesses
Recommended 7 days.
Archiving businesses
Set the data backup retention period to 7 days. Manually back up data based on actual business needs and delete them promptly after use.
Testing businesses
Set the data backup retention period to 7 days. Manually back up data based on actual business needs and delete them promptly after use.
5. Can Isolated Instances Still Download Backups?
Yes.
Yearly/monthly subscription instances: Starting from the 8th day after instance expiration (that is, 7 days after expiration), the instance will be isolated and moved to the recycle bin. At this point, rollback and manual backups are prohibited, while automatic backups continue. You can download backups by going to the instance's Operation column > More. Backup data exceeding the free tier will still incur charges until the instance is terminated.
Pay-as-you-go instances: After 24 hours of instance expiration, the instance will be isolated and moved to the recycle bin. At this point, rollback and manual backups are prohibited, while automatic backups continue. You can download backups by going to the instance's Operation column > More. Backup data exceeding the free tier will still incur charges until the instance is terminated.
Related APIs
API
Description
Rename Backup
This API (ModifyBackupName) is used to modify backup task names.
Query Backup List
This API (DescribeBackups) is used to query the backup list.
Query single-database backup file details
This API (DescribeBackupFiles) is used to query single-database backup details.

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Feedback

Tool	Description
Time Frame	Click to select the time range for the backup files to be queried. It supports quick selection of last 24 hours, last 7 days, last 15 days, last 30 days, and also supports custom time range (within any 30-day period when backups are generated), with the time range specifiable down to the second.
Search box	Data Backup: Within , you can select resource attributes to filter out the backups to be queried. Resource attributes include Backup ID, Backup Name, Database Name, Backup Method, Backup File Format, Backup Object, Backup Status. Log Backup: Within , you can select resource attributes to filter out the backups to be queried. Resource attributes include Backup ID, Backup File Format, Backup Status. Note: Multiple resource attributes should be separated by the Enter key. In resource attributes, Backup Name and Database Name support fuzzy matching, while Backup ID does not support fuzzy matching; other resource attributes are option-based settings.
Refreshing	Click to refresh the list.
Settings	Click to customize the fields displayed in the list. You can select or deselect fields to configure the display, and drag fields to reorder their sequence in the list. The three fields - Backup ID, Filename/Backup Name, and Operation - cannot be deselected by default and their order cannot be adjusted.
Download	Click to export the current page data of the list locally.

Data Backup List Fields	Description
Backup ID	Backup Set Unique ID.
File Name/Backup Name	The filename and backup name for data backups. For automatic backups, the system automatically generates default filenames and backup names. For manual backups, if no backup name is specified, the system also generates a default name. The backup name can be modified.
Start/End Time	The start time and end time of the backup. Note: The time displayed here is Beijing Time.
Backup Size	The size of the backup files can be sorted.
Backup Duration	Displays the duration consumed by the backup and supports sorting.
Backup Object	The options for this field include: All, Instance Backup, Multi-Database Backup, and can be filtered.
Backup Mode	The options for this field include: All, Automatic - regular, Automatic - scheduled, Manual, and support filtering.
Upload Backup File	Backup file format. The options for this field include: All, Unarchived files, Archive file, and support filtering.
Backup Type	The backup type is physical - full backup.
Backup Region	The region where the backup is stored. This field displays the region corresponding to the backup.
Backup Status	The options for this field include: All, Successful, Failed, Backing up, Waiting, and support filtering, with statuses displayed per region.
Backup Progress	Database backup progress percentage.
Expiration Time	This field displays the expiration time of corresponding backups and supports sorting.
Operation	Download: When the backup file is in the form of archived backup files, the operation column will directly display the download button. View Details: When the backup file is in the form of single-database backup files, the operation column will display View Details. Click View Details, and you can view the backup information of the specific database in the pop-up window. Click Download to download the backup of the corresponding database. Rollback: Click Rollback, and you will be redirected to the rollback operation page. More > Convert into Scheduled: If the instance has enabled regular backup retention, you can use Convert into Scheduled to retain conventional backups generated by automatic backups as regular backups. More > Delete: Manual backups support saving storage space through the delete operation.

Field of the Log Backup List	Description
Backup ID	Backup unique ID.
File Name	The name of the log backup file. It is generated by the system by default and cannot be modified.
Start/End Time	The start time and end time of the backup. Note: The time displayed here is Beijing Time.
Backup Duration	Displays the duration consumed by the backup and supports sorting.
Backup Size	The size of the backup files can be sorted.
Upload Backup File	Backup file format. The options for this field include: All, Unarchived files, Archive file, and support filtering.
Backup Region	The region where the backup is stored. This field displays the region corresponding to the backup.
Backup Status	The options for this field include: All, Successful, Failed, Backup in progress, Pending, and support filtering, with statuses displayed per region.
Expiration Time	This field displays the expiration time of corresponding backups and supports sorting.
Operation	Download: When the backup file is in the form of archived backup files, the operation column will directly display the download button. View Details: When the backup file is in the form of single-database backup files, the operation column will display View Details. Click View Details, and you can view the backup information of the specific database in the pop-up window. Click Download to download the backup of the corresponding database.

Workload Scenario	Backup Retention Period
Core businesses	Recommended 7 days - 7300 days.
Non-core and non-data businesses	Recommended 7 days.
Archiving businesses	Set the data backup retention period to 7 days. Manually back up data based on actual business needs and delete them promptly after use.
Testing businesses	Set the data backup retention period to 7 days. Manually back up data based on actual business needs and delete them promptly after use.

API	Description
Rename Backup	This API (ModifyBackupName) is used to modify backup task names.
Query Backup List	This API (DescribeBackups) is used to query the backup list.
Query single-database backup file details	This API (DescribeBackupFiles) is used to query single-database backup details.

tencent cloud

Backup List Tool Item

Operation Steps

FAQs

1. Can Backups Beyond the Retention Period Still Be Downloaded or Restored?

2. Backups Can Be Deleted Manually

3. Can Data and Log Backup Be Disabled?

4. How to Reduce Backup Space Overhead?

5. Can Isolated Instances Still Download Backups?

Related APIs