TencentDB for SQL Server supports automatic backup and manual backup. This document describes how to create a manual 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.
We recommend you not modify the restoration mode for Basic Edition instances, which is full mode by default. If you modify it to the simple mode, the log chain will be broken and manual backup will fail.
The backup link is as follows: Initially, backup files are uploaded to a local temporary backup space before being transferred to the COS backup space. Backup files within the local temporary backup space are retained for one day. For the cloud disk edition architecture, the size of the local temporary backup space is 50% of the purchased disk size. In instances where the backup files are considerably large, there may arise a scenario where the backup process is hindered due to insufficient local temporary backup space.
Prerequisites
Before performing manual backup, make sure that you have created a database. For more information, see Creating Database.
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 Backup Management tab, click Manual Backup.
4. Complete the following configurations in the pop-up dialog box and click OK.
Note：
The time required for backup is determined by the size of the backup file, which takes approximately 5 to 120 minutes.
Parameter
Overview
Backup name
Set the backup name for manual backup, which contains up to 128 characters consisting of Chinese characters, English letters, numbers, and special characters.
Backup policy
Instance backup: Perform backup for all databases of the entire instance.
Multi-database backup: If you choose multi-database backup, you need to select the databases to be backed up. It supports selecting all databases with one click and sorting databases alphabetically by the first letters of their names (in ascending or descending order).
Retention period policy
Set the retention period policy for manual backup files:
Custom policy: indicates that the retention period policy for backup files follows that of automatic backups.
Following instance lifecycle: indicates that the backup file will be saved following the instance lifecycle if they are not manually deleted. They will be deleted until the instance is terminated.
5. After the manual backup is completed, you can query it in the backup list on the Backup Management tab.
