Configuring Automatic Backup
Last updated: 2022-08-04 15:57:42
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
- Log in to the TencentDB for SQL Server console.
- 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.
- On the instance management page, select Backup Management and click Auto-Backup Settings.
- 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.
Was this page helpful?