All Products
Search
Document Center

Database Backup:Get started with DBS

Last Updated:Jan 22, 2024

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.

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

  • Ease of use

  • Efficiency

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

  • Ease of use

  • Ease of management

  • Creation of multiple backup schedules at a time

Method 1: (Recommended) Create a backup schedule for a database

image
  1. Create a backup schedule.

    You must purchase a backup schedule for the database that you want to back up.

  2. Configure the 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 for a database, 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 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

image
  1. Add data sources to DBS.

    After you manually add databases to DBS as data sources, you can back up and manage the data sources 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 databases.

    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.

  4. Optional. Restore a database.

    After a backup is created for a database, 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 Use the emergency recovery feature for an ApsaraDB RDS for MySQL instance.

References

Video tutorials on getting started with DBS

Back up databases

Restore databases