tencent cloud

All product documents
Cloud Object Storage
SQL Server Data Backup
Last updated: 2024-10-24 18:41:53
SQL Server Data Backup
Last updated: 2024-10-24 18:41:53

Overview

SQL Server data backup is a SCF-based database backup feature provided by COS. It allows you to dump SQL Server data to COS so that data can be stored persistently and protected from data loss or corruption. After you set a backup function rule for a specified bucket, SCF will scan your server backup files periodically and dump them in the bucket.

Notes

SQL Server data backup functions back up only the backup files of SQL Server. If SQL Server backup is not enabled, the backup functions cannot be executed.
If you have added a SQL Server data backup rule to your bucket in the COS console, you can view it in the SCF console. DO NOT delete the function. Otherwise, your rule may not take effect.
SQL Server data backup is supported in SCF-enabled regions, including Guangzhou, Shanghai, Beijing, Chengdu, Hong Kong (China), Singapore and Silicon Valley. For more supported regions, see SCF Documentation.

Directions

1. Log in to the COS console.
2. On the left sidebar, click Application Integration > Data Backup.
3. Find SQL Server Backup and click Configure Backup Rule to go to the rule configuration page.
4. Click Add Function.
Note:
If you haven't activated SCF, go to the SCF console to activate it and authorize the service as instructed.
5. In the pop-up window, configure the following items:
Function Name
Uniquely identifies a function and cannot be modified after being set. You can view the function in the SCF console.
Associated Bucket
A bucket to store SQL Server backup files.
Trigger Period
Triggers the backup operation for the SQL Server backup function. Every day, every week, and custom periods are supported.
Cron Expression
If you use a custom period, you can use Cron to specify the trigger period rule. Cron follows the local Standard Time. For detailed configuration policies, see Timer Trigger Description.
Database Instance
SQL Server instance list of the region where the current bucket resides
Delivery Path
Delivery path prefix of the backups. If not specified, backups will be stored in the root directory of the bucket.
SCF Authorization
SCF needs to be authorized so that it can read the SQL Server instances as well as their backup files, and save the backup files to the specified bucket.

6. Click Confirm. You can perform the following operations on the created function:
Click Log to view the historical running status of the SQL Server data backup. If an error is reported, you can click Log to quickly redirect to the SCF console for viewing the error log details.
Click More > Edit to modify the SQL Server data backup rule.
Click More > Delete to delete the unwanted SQL Server data backup rule.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 available.

7x24 Phone Support
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon