This topic describes how to download the unencrypted data and log backup files of an ApsaraDB RDS for SQL Server instance. You can archive the downloaded backup files. You can also restore data from the downloaded backup files to an on-premises database.

Limits

A Resource Access Management (RAM) user that has only the read permissions is not authorized to download data or log backup files. You can grant the required permissions to the RAM user by using the RAM console.

Database engine Download of data backup files Download of log backup files
SQL Server You can download full and incremental physical backup files. You can also download the full physical backup files of individual databases.
Note You cannot download snapshot backup files. For more information, see snapshot backup files.
You can download log backup files without the need to consider the instance configuration.

Procedure

Note You can use Database Backup (DBS) to implement automated backup and automated download. For more information, see Back up one or more databases.
  1. Go to the Backup and Restoration page.
    1. Log on to the ApsaraDB for RDS console. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where your RDS instance resides.
      选择地域
    2. Find your RDS instance and click its ID. In the left-side navigation pane, click Backup and Restoration.
  2. Click the Data Backup or Log Backup tab.
    • If you want to download a data backup file, click the Data Backup tab.
    • If you want to download a log backup file, click the Log Backup tab.
  3. Select a time range to query backup files.
  4. Find the data or log backup file that you want to download. Then, click Download in the Actions column.
    Note
    • If you cannot find Download in the Actions column, you can see the "Limits" section of this topic.
    • If you want to download a data backup file to restore data, we recommend that you select the data backup file that is created at the closest point in time.
    • If you want to download a log backup file to restore data to an on-premises database, make sure that the start time of the log backup file falls in a specific time range. The range starts after the time when the data backup file you use is generated and ends before the point in time to which you want to restore data.
  5. In the Download Instance Backup Set dialog box, click Download.
    Download method Description
    Download Use a browser to download the backup file.
    Copy Internal URL Copy the internal URL to download the backup file. If your Elastic Compute Service (ECS) and RDS instances reside in the same region, you can log on to the ECS instance and use the internal URL to download the backup file. This method is fast and secure.
    Copy Public URL Copy the public URL to download the backup file. If you want to use other tools to download the backup file, we recommend that you select this download method.
    Note If you use a Linux operating system, you can run the following command to download a backup file:
    wget -c '<The URL that is used to download the backup file>' -O <The name of the backup file>
    • The -c parameter specifies to enable resumable download.
    • The -O parameter specifies to save the downloaded backup file by using the specified name. We recommend that you use the default file name that is provided in the specified URL.
    • If the specified URL contains more than one parameter, we recommend that you enclose the URL in a pair of single quotation marks (').
    Download a data backup file