tencent cloud

Feedback

Cross-Account Backup Restoration

Last updated: 2024-01-18 17:25:32
    TencentDB for SQL Server supports intra-region cross-account backup restoration. This document describes how to get the backup file download URL of an instance under account A and then restore data under account B in the same region.

    Note

    After getting the backup file download URL of an instance under account A, perform backup restoration under account B. The two accounts need to be in the same region.
    This backup restoration mode currently supports backup files in BAK, TAR, and ZIP formats.
    To use intra-region cross-account backup restoration, the form of the backup file obtained in the console must be unarchived file.
    Currently, the backup file download URL needs to be decoded as detailed below.

    Step 1. Obtain the backup file download URL under account A

    1. Log in to the TencentDB for SQL Server console with account A, and click an instance ID in the instance list to enter the instance management page.
    2. On the instance management page, select the Backup Management tab and click View Details in the Operation column of the target unarchived file in the data backup list.
    
    
    3. Click Download in the pop-up window and copy the download URL.
    
    

    Step 2. Decode the URL

    Click here to decode the copied URL on the page redirected to.
    Note:
    Only the first part of the download URL needs to be decoded. Example: Suppose a download URL is: 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?**********

    Step 3. Restore data under account B

    Copy the final URL for backup restoration obtained in step 2.
    1. Log in to the TencentDB for SQL Server console with account B and click an instance ID in the instance list to enter the instance management page.
    2. On the instance management page, select Backup and Restoration > Create.
    
    
    3. In the pop-up window, configure the following items and click Create Task.
    
    
    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.
    4. In the Upload Backup File window, paste the URL and click Save.
    
    
    5. Go to the Backup and Restoration tab, find the backup task you just created, and click Start in the Operation column.
    6. In the backup and restoration task list, check the migration task status. When it becomes Migration succeeded, the cross-account backup restoration is completed.
    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 avaliable.

    7x24 Phone Support