nav-img
Advanced

Downloading a Backup File

Scenarios

This section describes how to download a manual backup or an automated backup to a local device and restore data from the backup file.

Method 1: Using Current Browser+

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service.
  4. On the Backups page, locate the backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the displayed page, locate the target backup to be downloaded and click Download in the Operation column.

  5. In the displayed dialog box, select Use Current Browser for Download Method and click OK.
  6. Restore data locally as required by referring to Restoring from Backup Files to a Self-Built SQL Server Database Using SSMS.

Method 2: Using Download URL

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click Service List. Under Database, click Relational Database Service.
  4. On the Backups page, locate the backup to be downloaded and click Download in the Operation column.

    Alternatively, click the target DB instance. In the navigation pane on the left, choose Backups & Restorations. On the displayed page, locate the target backup to be downloaded and click Download in the Operation column.

  5. In the displayed dialog box, select a method to download backup data.

    In the displayed dialog box, select Use Download URL for Download Method, click to copy the URL, and enter the URL in your browser.

    For Microsoft SQL Server DB instances, the URLs of all the backup files are displayed. You can download the backup files of a specific database.

    • You can use other download tools to download backup files.
    • You can also run the following command to download backup files:

      wget -O FILE_NAME --no-check-certificate "DOWNLOAD_URL"

      Variables in the commands are as follows:

      FILE_NAME: indicates the new backup file name after the download is successful. The original backup file name may be too long and exceed the maximum characters allowed by the client file system. You are advised to use the -O argument with wget to rename the backup file.

      DOWNLOAD_URL: indicates the path of the backup file to be downloaded. If the path contains special characters, escape is required.

  6. Restore data locally as required by referring to Restoring from Backup Files to a Self-Built SQL Server Database Using SSMS.