This topic describes how to download unencrypted data and log backup files from an ApsaraDB RDS for SQL Server instance. This allows you to manage the files by using an organized method. In addition, you can use the files to restore the data of the RDS instance to an on-premises database.

Limits

A RAM user with only read-only permissions cannot download data or log backup files. You can grant the required permissions to the RAM user in the RAM console. For more information, see Grant backup file download permissions to a RAM user with only read-only permissions.

Database engine Download of data backup files Download of log backup files
SQL Server You can download the full and incremental physical backup files of your RDS instance. You can also download the full physical backup files of individual databases on your RDS instance. You can download log backup files. You do not need to be concerned about the configuration of your RDS instance.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the upper-left corner of the page, select the region where the target instance is located.Select a region
  3. Find the target RDS instance and click its ID. The Basic Information page appears.
  4. In the left-side navigation pane, click Backup and Restoration.
  5. Click the Data Backup or Log Backup tab.
    • To download data backup files, click the Data Backup tab.
    • To download binary log files, click the Log Backup tab.
  6. Specify a time range to query the data backup files or binary log files created during that period.
  7. Find the data backup file or binary log file you want to download, and click Download in the Actions column.
    Note
    • If the Download button is not available, see the Limits section in this topic.
    • If you want to restore data by using a data backup file, select the file that was created at the point in time closest to the point in time requiring data restoration.
    • If you use a binary log file to restore data to an on-premises database, make sure that the following requirements are met:
      • The Instance ID of the binary log file on the Log Backup tab must be the same as the Instance No. displayed on the Data Backup tab.
      • The start time of the binary log file must be later than the start time of the specified time range and earlier than the point in time requiring data restoration.
  8. In the Download Binary Log dialog box that appears, click Download. Download method
    Download method Description
    Download Use a browser to download the backup file.
    Copy Internal Download URL To only copy the internal download URL of the file. If your ECS instance and RDS instance reside in the same region, you can log on to the ECS console and use the internal download URL to download the file. This method is faster and more secure.
    Copy External Download URL To only copy the external download URL of the file. If you want to use other tools to download the file, select this method.
    Note If you are using a Linux operating system, you can run the following command to save the file:
    wget -c '<The URL from which to download the file>' -O <The name of the file you want to download>
    • The -c parameter enables resumable download.
    • The -O parameter saves the downloaded file by its specified name. We recommend that you use the file name from the download URL.
    • If the download URL contains more than one parameter, we recommend that you enclose the download URL in a pair of single quotation marks (').
    Log backupData backup