Tencent Cloud

Recent Pages

Creating Manual Backup

Last updated: 2024-07-30 16:34:32

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.
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 Backup Management tab, click Manual Backup.
4. In the pop-up window, enter the backup name, select the backup policy, and click OK.
Backup Name: Set the manual backup name, which can contain up to 128 letters, digits, or underscores.
Backup Policy:
Instance backup: Backs up all databases in the entire instance.
Multi-database backup: Backs up selected databases.
Note: 
The time it takes to complete the backup is subject to the backup file size and ranges from around 5 to 120 minutes.
5. After the manual backup is completed, you can query it in the backup list on the Backup Management tab.