Overview of the backup set download feature - Database Backup

Database Backup (DBS) allows you to back up and restore ApsaraDB databases and self-managed databases that are hosted on Elastic Compute Service (ECS) instances in a flexible manner. You can also download backup sets from the cloud to your on-premises machine to enhance data security. Backup sets can be manually or automatically downloaded. You can use downloaded backup sets to restore on-premises databases, analyze and audit data in Excel, and back up data to on-premises storage.

How backup set download works

DBS packages, compresses, and converts backup files to downloadable CSV files. The whole process takes about 15 minutes. These files can be manually downloaded or automatically downloaded by using DBS backup gateways. For more information, see Manually download a backup set and Configure automatic download of backup sets.

Limits

Note

Before you download a backup set, check its validity period. The download process takes an amount of time. If the backup set that you want to download is about to expire, we recommend that you extend the retention period of the backup set in advance to prevent data from being automatically deleted during the download process. After the backup set is downloaded, you can change its retention period to the original setting. For more information, see Modify the lifecycle of a backup schedule.

Item	Logical backup	Physical backup
Backup destination storage type	Only DBS built-in storage is supported. Object Storage Service (OSS) buckets are not supported.	Only DBS built-in storage is supported. OSS buckets are not supported.
Full data	The following types of databases are supported: MySQL SQL Server MariaDB PostgreSQL Oracle MongoDB Note MongoDB data is in the `JSON` format. Other data is in the `CSV` format.	The following types of databases are supported: MySQL SQL Server Note MySQL data is in the same format as the data generated by using Percona XtraBackup and is compressed. SQL Server data is in the same format as the data generated by using the native backup command and is compressed.
Incremental data	The following type of database is supported: MySQL Note Data is in the native format of MySQL.	The following types of databases are supported: MySQL SQL Server Note Data is in the same format as its full data.

References

For information about the differences between DBS built-in storage and OSS buckets, see Built-in storage and OSS.