This topic describes how to download the unencrypted data backup files 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 on-premises databases.

Limits

If the AliyunRDSReadOnlyAccess policy is attached to a RAM user, the RAM user has only the read permissions and cannot download data backup files or log backup files. You must attach the AliyunRDSFullAccess policy to your 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 regardless of the instance configuration. For more information, see the "Download log backup files" section of this topic.
Note

Billing

ApsaraDB RDS provides a free quota for backup downloads over the Internet. Since 0:00 on November 25, 2021, you are charged for the excess traffic that you consume to download backup files over the Internet. For more information, see [Notice] Upgrade and commercial release of the backup download feature.

  • Downloads over an internal network: You are not charged for the traffic that you consume.
  • Downloads over the Internet: After the free quota is exhausted, you are charged a daily fee for the excess traffic that you consume. For more information, see Billing overview.
  • Free quota for backup downloads over the Internet: The free quota is 500 GB per month.
Note

To view the volume of traffic that you consume to download backup files over the Internet, you can log on to the ApsaraDB RDS console, find your RDS instance, go to the Basic Information page, and then view the Backup Downloads parameter in the Usage Statistics section.

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. Specify the time range that you want to query.
  5. Find the data backup file that you want to download. In the Actions column, click Download Instance Backup.
    Note
    • If Download Instance Backup cannot be found in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file and use the file to restore data, we recommend that you select the data backup file that is created at the point in time closest to the point in time at which the required data exists.
    • If you want to download a log backup file and use the file to restore data to an on-premises database, the start time of the log backup file must be within a specific time range. The time range starts after the point in time at which the selected data backup file is generated and ends before the point in time to which you want to restore data.
  6. In the dialog box that appears, click Download or copy the URL from which you can download the backup file.
    • Copy Internal URL: You can log on to your Elastic Compute Service (ECS) instance and use the internal URL to download the backup file. This method is faster and more secure. It is suitable if your ECS instance resides in a virtual private cloud (VPC) and can connect to the RDS instance over an internal network.
    • Copy Public URL: You can use the public URL to download the backup file. This method is suitable if the RDS instance cannot be connected over an internal network.
    Notice
    • If you download the backup file from the internal URL, your ECS instance must reside in the same VPC in the same region as the RDS instance. If your ECS instance resides in a different VPC or in the classic network, you cannot download the backup file from the internal URL.
    • When you click Download, the backup file is downloaded from the public URL. In this case, you are charged for the excess Internet traffic that you consume.

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. Specify the time range that you want to query.
  5. Find the data backup file that you want to download. In the Actions column, click Download Database Backup.
  6. On the Download Backup Files of Individual Database page, find the data backup file that you want to download, and click Download in the Actions column.
    Note
    • If Download Instance Backup cannot be found in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file and use the file to restore data, we recommend that you select the data backup file that is created at the point in time closest to the point in time at which the required data exists.
    • If you want to download a log backup file and use the file to restore data to an on-premises database, the start time of the log backup file must be within a specific time range. The time range starts after the point in time at which the selected data backup file is generated and ends before the point in time to which you want to restore data.
  7. In the dialog box that appears, click Download or copy the URL from which you can download the backup file.
    • Copy Internal URL: You can log on to your Elastic Compute Service (ECS) instance and use the internal URL to download the backup file. This method is faster and more secure. It is suitable if your ECS instance resides in a virtual private cloud (VPC) and can connect to the RDS instance over an internal network.
    • Copy Public URL: You can use the public URL to download the backup file. This method is suitable if the RDS instance cannot be connected over an internal network.
    Notice
    • If you download the backup file from the internal URL, your ECS instance must reside in the same VPC in the same region as the RDS instance. If your ECS instance resides in a different VPC or in the classic network, you cannot download the backup file from the internal URL.
    • When you click Download, the backup file is downloaded from the public URL. In this case, you are charged for the excess Internet traffic that you consume.

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. Specify the time range that you want to query.
  5. Find the log backup file that you want to download. In the Actions column, click Download.
    Note
    • If Download Instance Backup cannot be found in the Actions column, see the "Limits" section of this topic.
    • If you want to download a data backup file and use the file to restore data, we recommend that you select the data backup file that is created at the point in time closest to the point in time at which the required data exists.
    • If you want to download a log backup file and use the file to restore data to an on-premises database, the start time of the log backup file must be within a specific time range. The time range starts after the point in time at which the selected data backup file is generated and ends before the point in time to which you want to restore data.
  6. In the dialog box that appears, click Download or copy the URL from which you can download the backup file.
    • Copy Internal URL: You can log on to your Elastic Compute Service (ECS) instance and use the internal URL to download the backup file. This method is faster and more secure. It is suitable if your ECS instance resides in a virtual private cloud (VPC) and can connect to the RDS instance over an internal network.
    • Copy Public URL: You can use the public URL to download the backup file. This method is suitable if the RDS instance cannot be connected over an internal network.
    Notice
    • If you download the backup file from the internal URL, your ECS instance must reside in the same VPC in the same region as the RDS instance. If your ECS instance resides in a different VPC or in the classic network, you cannot download the backup file from the internal URL.
    • When you click Download, the backup file is downloaded from the public URL. In this case, you are charged for the excess Internet traffic that you consume.