Database Backup (DBS) provides features such as full backup, incremental backup, and data restoration. This topic describes how to create and configure a DBS backup schedule, back up databases, and restore databases. This helps you understand and get started with database backup and management.
If you are new to DBS, we recommend that you familiarize yourself with DBS first. For more information, see What is DBS?
For information about whether DBS supports the backup and restoration of your database and the granularity of database backup and restoration, see Database engines and features and Backup and restoration overview.
Backup and restoration methods
The following table describes the methods to back up and restore databases.
Method | Description | Intended user | Benefit |
Method 1: (Recommended) Create a backup schedule for a database | You can purchase a backup schedule for the database that you want to back up and perform simple configurations for the backup schedule. After a backup is created for a database, you can restore the database based on your business requirements. | Individual users or small-sized enterprises |
|
Method 2: Add data sources to DBS and create one or more backup schedules for the data sources | You need to only add databases to DBS as data sources once. Then, you can create backup schedules for the data sources and manage backups on demand. You can add ApsaraDB instances and self-managed databases of different database engines to DBS as data sources for management. After a backup is created for a database, you can restore the database based on your business requirements. Note For information about supported database engines, see Supported data sources. | Large-sized enterprises |
|
Method 1: (Recommended) Create a backup schedule for a database
You must purchase a backup schedule for the database that you want to back up.
Configure the backup schedule.
After you configure the backup schedule, DBS automatically backs up the database based on your configurations.
Optional. Restore a database.
After a backup is created for a database, you can restore the database based on your business requirements.
NoteDBS provides a sandbox solution based on copy data management (CDM). You can use the sandbox feature of DBS to create a sandbox instance to restore data in a backup set in a short period of time. For more information, see Use the emergency recovery feature for an ApsaraDB RDS for MySQL instance.
Method 2: Add data sources to DBS and create one or more backup schedules for the data sources
After you manually add databases to DBS as data sources, you can back up and manage the data sources on demand.
Create a backup policy template.
A backup policy template contains configuration items for a backup schedule, such as the backup method, storage method, backup frequency, backup cycle, backup start time, and storage pools.
You must create a backup schedule for the data sources that you add, and select a backup policy template when you configure the backup schedule. Then, DBS backs up the data sources based on the backup policy template of the backup schedule.
Optional. Restore a database.
After a backup is created for a database, you can restore the database based on your business requirements.
NoteDBS provides a sandbox solution based on CDM. You can use the sandbox feature of DBS to create a sandbox instance to restore data in a backup set in a short period of time. For more information, see Use the emergency recovery feature for an ApsaraDB RDS for MySQL instance.
References
For information about the specifications of backup schedule types and suggestions on selecting a backup schedule type, see Select a backup schedule type.
For information about the definitions of and differences between logical backup and physical backup, see Logical backup, physical backup, and snapshot-based backup and Select a backup method.
For information about backup and restoration scenarios, such as backup to the cloud, geo-redundancy, backup security, and quick restoration, see Common scenarios.
For information about fees that may be incurred for a backup schedule, see Billing FAQ.
Video tutorials on getting started with DBS
Back up databases
Restore databases