Database Backup (DBS) allows you to restore database backups to self-managed databases, ApsaraDB databases, or DBS sandbox instances.

Prerequisites

At least one data backup is complete. For more information, see Configure a backup schedule.

Introduction

This topic describes only the following conventional methods for restoring databases:
  • Restore databases to self-managed databases.
  • Restore databases to ApsaraDB databases.

DBS also provides the sandbox feature based on the copy data management (CDM) technology. This feature allows you to restore databases with a recovery time objective (RTO) of several seconds. You can analyze, test, and verify data in a sandbox instance. For more information, see Quick start.

Billing

The restoration feature is free of charge. However, if you restore a database to a new ApsaraDB instance, you are charged for the new instance.

Procedure

This example describes only a general procedure for restoring databases. The specific restoration procedure varies based on database engines. For more information about configuration examples for different database engines, see Backup and restore scenarios.

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules. On the Backup Schedules page, select a region in the upper-left corner.
  3. On the Backup Schedules page, find the ID of the backup schedule that you want to use to create a restore task, and click Manage in the Actions column.
  4. On the Configure Task page, click Restore Database in the upper-right corner.
  5. In the Set Time Restored To step of the Create Restore Task wizard, set the parameters in the Set Time Restored To and Configure Destination Database sections. Then, click Next in the lower-right corner of the page.
    Restore a MySQL database
    Note DBS allows you to restore a database such as MySQL or SQL Server to a new ApsaraDB RDS instance without the need to create the instance in advance.
  6. In the Configure Objects to Restore step, set the Conflict Handling parameter and specify the databases or tables to be restored in the Objects to Restore section.
    DBS can restore an entire database instance, one or more databases, or one or more tables. For more information, see Restore data by database or table. Specify the databases or tables to be restored
  7. In the lower-right corner of the page, click Precheck.
    DBS checks the preceding configurations, database connectivity, and database permissions.
  8. After the Precheck Passed message appears in the Precheck dialog box, click Start Task.
    To view the database restoration progress, click Restore Tasks in the left-side navigation pane. View the restoration progress
    Note The amount of time used to restore a database depends on the specification of the backup schedule and the size of the database. For more information, see Performance tests on backup and restoration.

    If you restore a database to a new ApsaraDB RDS instance, DBS takes about 5 to 10 minutes to create the instance. After the database is restored, you can view the new ApsaraDB RDS instance in the ApsaraDB RDS console. Alternatively, perform the following steps to view the new ApsaraDB RDS instance: On the Restore Tasks page, click the ID of the restore task. On the page that appears, click the ID of the ApsaraDB RDS instance in the Basic Information section. You are navigated to the ApsaraDB RDS console.

References of API operations