View Backup Overview (Region Dimension)
Last updated:2026-01-27 16:16:43
TencentDB for SQL Server provides a backup overview page to help you quickly understand backup space usage and backup trends. This article describes how to view the backup overview by region through the console.
Supported Dimensions Description
This article describes how to view the backup overview at the region dimension, which means that through this document, you will see the backup overview of a specific region.
TencentDB for SQL Server also provides a backup overview at the instance dimension. For details, see View Backup Overview (Instance Dimension).
Scenarios
TencentDB for SQL Server allocates backup space occupied by instance backup files on a per-region basis. The backup space represents the total storage space for all SQL Server database backups within that region, including automatic data backups, manual data backups, and log backups, as well as both local backups and cross-region backups. Cross-region backups are counted toward the backup region of the primary instance to which they belong. That is: although cross-region backups are stored in other regions, their backup volume is counted in the backup region of the primary instance. Backup fees are calculated based on the backup pricing of the storage region (that is, the destination region of the cross-region backup).
Extending the backup retention period or increasing the frequency of manual backups will increase the backup storage space. You can view the backup overview to understand the backup space statistics and trends for all instances in each region under your account, and to view real-time backup space statistics for individual instances.
On the console's Database Backup page, you can perform the following queries and operations:
View Backup Overview: On the overview page, you can view backup space statistics and trends for all instances in each region under your account, as well as real-time backup space statistics for individual instances.
View Data Backup Summary: On the Data Backup page, you can query the data backup details of all instances in a specific region.
View Log Backup Summary: On the Log Backup page, you can query the log backup details of all instances in a specific region.
Set Download Limit: On the download configuration page, you can set or modify the download restrictions for backup files in the current region.
View Backup Overview
1. Log in to the SQL Server console.
2. In the left sidebar, select Database Backup.
3. On the Database Backup page, you are taken to the Overview page by default, where you can view the following information.
Backup Overview
Overview by Data Dimension
On the right side of the Backup Overview, select Data Overview, and you can view the following information:
Local Backup: Total backup size, total number of backup files, average backup file size, and remaining free backup space in the current region.
Data Backup: Total data backup space size, total number of data backup files, and average size of each data backup file in the current region. Click View to jump to the Database Backup > Data Backup page to view details. You can also view the size and number of files for automatic and manual backups in Data Backup. When the mouse is hovered over automatic backup data, the size and number of files for both regular and periodic backups within automatic backups will be displayed.
Log Backup: Total log backup space size, total number of log backup files, and average size of each log backup file in the current region. Click View to jump to the Database Backup > Log Backup page to view details. You can also view the size and number of files for automatic backups in Log Backup.
Cross-region Backup: Total cross-region backup size, total number of cross-region backup files, and average size of each cross-region backup file. You can also check the size and number of files for both data backups and log backups within cross-region backups. Cross-region backups do not consume free backup space and are billed separately. For billing details, see Cross-region Backup Billing Details.
Overview by File Distribution Status
On the right side of the Backup Overview, select File Distribution. You can visually view the distribution percentage charts for both local and cross-region backups, allowing you to quickly grasp an overview of the backup distribution.
Instance Backup Real-Time Statistics
Local Backup Real-Time Statistics by Instance
Under Instance Backup Real-Time Statistics, select Local Backup to view real-time statistics of local backups for each instance in the current region.
The list is sorted by total backup size by default. (Note: Other sortable items are sorted by file size, not by the number of files.)
Click Instance ID/Name to jump to the corresponding instance details page.
Click Backup Details in the Operation column to jump to the Backup Management > Backup Overview page of the corresponding instance.
Real-time Statistics of Cross-region Backup by Instance
Under Instance Backup Real-Time Statistics, select Cross-Region Backup to view real-time statistics of cross-region backups for each instance in the current region.
The list is sorted by total backup size by default. (Note: Other sortable items are sorted by file size, not by the number of files.)
Click Instance ID/Name to jump to the corresponding instance details page.
Click Backup Settings in the Operation column to set the cross-region backup policy for the corresponding instance in the dialog.
Backup Trend
Local Backup - Type Trend
Under Backup Trend, choose Local Backup > Type Trend, then select the desired time period to view the backup trend by backup type in the current region.
Types include Free Quota, Total Backup, Data Backup, and Log Backup.
Hover over the chart to view the backup trend at a specific moment.
Local Backup - Instance Distribution
Under Backup Trend, choose Local Backup > Instance Distribution, then select the desired time period to view the backup trend for different instances in the current region.
Hover over the chart to view the backup trend for each instance on a specific day. Click Operation in the corresponding View column to jump to the Backup Management > Backup Overview page of the corresponding instance.
Cross-Region Backup - Type Trend
Under Backup Trend, choose Cross-Region Backup > Type Trend, then select the desired time period to view the backup trend by backup type for cross-region backups of instances in the current region.
Types include Total Backup, Data Backup, and Log Backup.
Hover over the chart to view the cross-region backup trend at a specific moment.
Cross-Region Backup - Instance Distribution
Under Backup Trend, choose Cross-Region Backup > Instance Distribution, then select the desired time period to view the cross-region backup trend for different instances in the current region.
Hover over the chart to view the cross-region backup trend for each instance on a specific day. Click Operation in the corresponding View column to jump to the Backup Management > Backup Overview page of the corresponding instance.
View Data Backup Summary
1. Log in to the SQL Server console.
2. In the left sidebar, select Database Backup.
3. On the Database Backup page, click Data Backup to go to the Data Backup page.
4. This Data Backup page displays a region-level summary of data backups. The fields in the backup list are consistent with those in the instance-level data backup list, with the only addition being the "Instance ID/Name" field, which shows all instances with data backups in the current region. For descriptions of other fields, see Viewing Backup Overview (Instance Level).
5. The following operations are available in the Data Backup list:
Clicking an Instance ID/Name: jumps to the instance details page of the corresponding instance.
Clicking View Details: redirects to the Backup Management > Data Backup page of the corresponding instance.
Clicking Rollback: redirects to the Restore page where you can perform rollback using the selected backup set or reconfigure the rollback settings.
Click More > Convert into Scheduled: This allows you to convert the selected backup files with backup method as "Automatic - Regular" to backup files with backup method as "Automatic - Scheduled" for long-term retention.
Clicking More > Delete: allows you to delete backup files with backup method as "Manual".
View Log Backup Summary
1. Log in to the SQL Server console.
2. In the left sidebar, select Database Backup.
3. On the Database Backup page, click Log Backup to go to the Log Backup page.
4. The Log Backup page displays a region-level summary of log backups. The fields in the backup list are consistent with those in the instance-level log backup list, with the only addition being the "Instance ID/Name" field, which shows all instances with log backups in the current region. For descriptions of other fields, see Viewing Backup Overview (Instance Level).
5. The following operations are available in the log backup list:
Clicking an Instance ID/Name: jumps to the instance details page of the corresponding instance.
Clicking View Details: redirects to the Backup Management > Log Backup page of the corresponding instance.
Set Download Limit
1. Log in to the SQL Server console.
2. In the left sidebar, select Database Backup.
3. On the Database Backup page, click Download Configuration to go to the Download Configuration page.
4. After Download Settings, click Modify.
5. Complete the following configurations, then click OK.
Parameter | Description |
download permission | You can choose Downloadable over both public and private networks or Downloadable only over a private network. |
Private network download restriction | When the download permission is set to Downloadable over both public and private networks, the private network download restriction defaults to Downloadable by all. When the download permission is set to Downloadable only over a private network, the private network download restriction defaults to Downloadable by all, with supported options including Downloadable by all or Downloadable if conditions are met. When Private network download restriction is set to Downloadable if conditions are met, you can restrict VPC and IP Address, with an AND relationship between both conditions. VPC: You can set to include or exclude specific VPCs. All VPCs created under the current region are available for selection, and multiple selections are supported. IP Address: You can set to include or exclude specific IP addresses. Multiple IP addresses should be separated by " , ". |
link validity period | Defaults to 12 hours. Options include: 15 minutes, 30 minutes, 1 hour, 6 hours, 12 hours, 24 hours, or 36 hours. |
Related APIs
API | Description |
This API (DescribeBackupStatistical) is used to query the real-time backup statistics list. | |
This API (DescribeBackupSummary) is used to query database backup overview information. | |
This API (DescribeCrossBackupStatistical) is used to query the cross-region backup real-time statistics list. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback