tencent cloud

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.

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 64 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.