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 backup files that you download. You can also restore data from these backup files to an on-premises database.

Limits

If the AliyunRDSReadOnlyAccess policy is attached to a Resource Access Management (RAM) user, the RAM user has read-only permissions and cannot download data or log backup files. You must attach the AliyunRDSFullAccess policy to the RAM user in the RAM console.

Database engine Download data backup files Download log backup files
SQL Server
Note You cannot download snapshot backup files. For more information, see Enable snapshot backups for an ApsaraDB RDS for SQL Server instance.
You can download log backup files without the need to consider the instance configuration. For more information, see the "Download log backup files" section of this topic.
Note

Download full or incremental physical backup files

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. Click the Data Backup tab.
  4. Select a time range to query backup files.
  5. Find the data backup file that you want to download. Then, click Download Instance Backup in the Actions column.
    Note
    • If you cannot find Download in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file that is used 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 that is used to restore data to an on-premises database, make sure that the start time of the log backup file is within the time range that you specify. The time 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.
  6. 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, from which you can download the backup file. If your Elastic Compute Service (ECS) instance and RDS instance 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, from which you can 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 are using 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 option specifies that resumable download is enabled.
    • The -O option specifies that the backup file that you download is saved by using the specified file name. We recommend that you use the default file name that is provided in the URL.
    • If the URL contains more than one parameter, we recommend that you enclose the URL in a pair of single quotation marks (').
    Download data backup files

Download the physical backup files of individual databases

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. Click the Data Backup tab.
  4. Select a time range to query backup files.
  5. Find the data backup file that you want to download. In the Actions column, choose Download Database Backup.
  6. On the Download Database Backup page, find the backup file that you want to download, and click Download in the Actions column.
    Note
    • If you cannot find Download in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file that is used 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 that is used to restore data to an on-premises database, make sure that the start time of the log backup file is within the time range that you specify. The time 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.
  7. In the Download Database Backup dialog box, click Download.
    Download method Description
    Download Use a browser to download the backup file.
    Copy Internal URL Copy the internal URL, from which you can download the backup file. If your Elastic Compute Service (ECS) instance and RDS instance 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, from which you can 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 are using 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 option specifies that resumable download is enabled.
    • The -O option specifies that the backup file that you download is saved by using the specified file name. We recommend that you use the default file name that is provided in the URL.
    • If the URL contains more than one parameter, we recommend that you enclose the URL in a pair of single quotation marks (').
    Download data backup files

Download log backup files

  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the left-side navigation pane, click Backup and Restoration.
  3. Click the Log Backup tab.
  4. Select a time range to query backup files.
  5. Find the log backup file that you want to download and click Download in the Actions column.
    Note
    • If you cannot find Download in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file that is used 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 that is used to restore data to an on-premises database, make sure that the start time of the log backup file is within the time range that you specify. The time 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.
  6. 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, from which you can download the backup file. If your Elastic Compute Service (ECS) instance and RDS instance 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, from which you can 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 are using 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 option specifies that resumable download is enabled.
    • The -O option specifies that the backup file that you download is saved by using the specified file name. We recommend that you use the default file name that is provided in the URL.
    • If the URL contains more than one parameter, we recommend that you enclose the URL in a pair of single quotation marks (').
    Download data backup files