Parameter | Description |
Task Name | The task name can contain up to 60 letters, digits, or underscores. |
Backup Upload Method | Local upload and download from COS. |
Restoration Mode | Full backups, full backups + logs, full backups + differential backups. |
Parameter | Description |
Restoration Mode | When you select full backups + logs or full backups + differential backups, there will be requirements for file names. You can click Get Backup Command to generate the corresponding backup command to generate the backup files that conforms to the file naming conventions. Full backups restoration: You cannot use the full backup name of "full backup + differential backup" or "full backup + log files". Full backups + differential backups restoration: Requirements for full backup file name: dbname_localtime_1full1_1noreconvery1.bak Requirements for incremental backup file name: dbname_localtime_1diff1_1noreconvery1.bak Requirements for the name of the last incremental backup file: dbname_localtime_1diff1_1reconvery1.bak Full backups + logs restoration Requirements for full backup file name: dbname_localtime_2full2_2noreconvery2.bak Requirements for log name: dbname_localtime_2log2_2noreconvery2.bak Requirements for the name of the last log: dbname_localtime_2log2_2reconvery2.bak |
Upload Backup | Click Upload to import the backup file locally |
Rename Database | It is optional. Once enabled, the original database name in the backup file will be reset and then designated as the new database name after it is restored to the cloud database, and you need to enter these two names. Note: Up to 5 databases can be renamed. If a database in the original database was not renamed, its name will remain unchanged after the backup restoration task is completed. |
Download Settings | Support Auto-restoration upon upload completion and *Start restoration manually.
Auto-restoration upon upload completion: The restoration task will be started immediately after you click Save.
Start restoration manually: Click Save, manually start the task on Backup and Restoration** page, and the uploaded backup files are only saved for 24 hours. |
Parameter | Description |
Restoration Mode | When you select full backups + logs or full backups + differential backups, there will be requirements for file names. You can click Get Backup Command to generate the corresponding backup command to generate the backup files that conforms to the file naming conventions. Full backups restoration: You cannot use the full backup name of "full backup + differential backup" or "full backup + log files". Full backups + differential backups restoration: Requirements for full backup file name: dbname_localtime_1full1_1noreconvery1.bak Requirements for incremental backup file name: dbname_localtime_1diff1_1noreconvery1.bak Requirements for the name of the last incremental backup file: dbname_localtime_1diff1_1reconvery1.bak Full backups + logs restoration Requirements for full backup file name: dbname_localtime_2full2_2noreconvery2.bak Requirements for log name: dbname_localtime_2log2_2noreconvery2.bak Requirements for the name of the last log: dbname_localtime_2log2_2reconvery2.bak |
COS Source File Link | Paste the source COS backup file link Note: When downloading files from COS, you need to pay attention to the permissions of the original COS file link. The following two permissions are supported: Public read permission: Copy the download address. Private read permission: Download via a pre-signed URL in COS. For more information, see Download via Pre-Signed URL. You need to pay attention to the case sensitivity of the .bak, .tar, and .zip file extensions. Only lowercase letters are supported, and uppercase letters are not supported. |
Rename Database | It is optional. Once enabled, the original database name in the backup file will be reset and then designated as the new database name after it is restored to the cloud database, and you need to enter these two names. Note: Up to 5 databases can be renamed. If a database in the original database was not renamed, its name will remain unchanged after the backup restoration task is completed. |
https://sqlserver-bucket-bj-1258415541.cos.ap-beijing.myqcloud.com/1312368346%2fsqlserver%2fmssql-8e5hjaiq%2fbackup%2fautoed_instance_58013012_AdventureWorksDW2012_2022_12_29023915.bak?**********
You only need to select the URL part that ends with .bak?
for decoding. Then, combine the output string with the other part of the URL to get the final URL for cross-account backup restoration.
For the above sample URL, take the following part for decoding:
https://sqlserver-bucket-bj-1258415541.cos.ap-beijing.myqcloud.com/1312368346%2fsqlserver%2fmssql-8e5hjaiq%2fbackup%2fautoed_instance_58013012_AdventureWorksDW2012_2022_12_29023915.bak?
It is decoded to:
https://sqlserver-bucket-bj-1258415541.cos.ap-beijing.myqcloud.com/1312368346/sqlserver/mssql-8e5hjaiq/backup/autoed_instance_58013012_AdventureWorksDW2012_2022_12_29023915.bak?
Then, the final URL for cross-account backup restoration is as follows:
https://sqlserver-bucket-bj-1258415541.cos.ap-beijing.myqcloud.com/1312368346/sqlserver/mssql-8e5hjaiq/backup/autoed_instance_58013012_AdventureWorksDW2012_2022_12_29023915.bak?**********
Parameter | Description |
Task Name | Enter the task name, which can contain up to 60 letters, digits, or underscores. |
Backup Upload Method | Select Download File from COS. |
Restoration Mode | Select Full Backup File. |
Was this page helpful?