Database Backup (DBS) provides features such as full backup, incremental backup, and data restoration. This topic describes the methods that are provided by DBS to back up and manage databases.

The following table describes the methods that are provided by DBS to back up and manage databases.

Method Description Intended user
Method 1: Create a backup schedule for a single database (recommended) You can create a backup schedule for a single database that you want to back up and configure the information about the database in the backup schedule. You do not need to add the database to DBS as a data source. Individual users or small-sized enterprises
Method 2: Add a database to DBS as a data source and create a backup schedule for the data source

You need only to 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.

Large-sized enterprises

Method 1: Create a backup schedule for a single database (recommended)

  1. Purchase a backup schedule.
    You must purchase a backup schedule for the database that you want to back up.
  2. Configure a backup schedule.
    After you configure the backup schedule, DBS automatically backs up the database based on your configurations.
  3. Optional:Restore a database.
    After a backup is created, you can restore the database based on your business requirements.
    Note DBS 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 Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database.

Method 2: Add a database to DBS as a data source and create a backup schedule for the data source

  1. Add a data source.
    After you add a database to DBS as a data source, you can back up and manage the data source on demand.
  2. 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.
  3. Back up one or more databases.
    You must select a backup policy template when you create a backup schedule. Then, DBS backs up the data source based on the backup policy template of the backup schedule.
  4. Optional:Restore a database.
    After a backup is created, you can restore the database based on your business requirements.
    Note DBS 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 Create a sandbox instance for the emergency disaster recovery of an ApsaraDB RDS for MySQL database.