DBS can restore data. You can restore database backups to local databases, cloud databases, or DBS sandboxes.

Prerequisites

Data is backed up once. For more information, see Configure a backup schedule.

Introduction

  • This topic describes only how to restore databases to ApsaraDB. You can restore databases to self-managed databases or ApsaraDB.
  • DBS also provides the sandbox feature based on the Copy Data Management (CDM) technology. This allows you to restore databases with recovery time objective (RTO) of several seconds. You can analyze, test and verify data in the sandbox. For more information, see Quick start.

Billing

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

Procedure

This example describes only the general configuration process. Restoration configurations for different database engines are different.

  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.
    Select a region
  3. On the Backup Schedules page, find Schedule ID and click Manage in the Actions column.
  4. On the Configure Task page, click Restore Database in the upper-right corner.
  5. On the Set Time Restored To page, configure Set Time Restored To and Configure Destination Database, and click Next.
    Restore a MySQL instance
    Note DBS allows you to restore a database such as MySQL, SQL Server, or PostgreSQL to a newly created ApsaraDB RDS instance.
  6. On the Configure Objects to Restore page, configure Restore Options and Objects to Restore.
    Configure a recovery object
    Note DBS can restore a backup schedule, one or more databases, or one or more tables. For more information, see Restore a single table.
  7. In the lower-right corner of the page, click Precheck.
    The system checks the preceding configuration options, database connectivity, and database permissions.
  8. If the Precheck Passed message appears, click Start Task.
    After you click Start Task, you can click Restore Tasks in the left-side navigation pane to view the database restoration progress on the details page of a backup schedule.View the restoration progress
    Note The restoration time depends on the data volume and backup specifications. For more information, see Performancedescription of backup and restoration.

References of API operations