Database Backup (DBS) allows you to back up data to cloud storage, restore backup sets to databases, and query cloud backup sets by using SQL statements.

Prerequisites

You can restore backup sets to MySQL, SQL Server, Oracle, PostgreSQL and ApsaraDB RDS for PPAS databases.

Procedure

  1. Log on to the DBS console.
  2. In the left-side navigation pane, click Backup Schedules.
  3. On the Backup Schedules page, click Manage in the Actions column corresponding to a backup schedule.
  4. In the left-side navigation pane, choose Backup Tasks > Full Data.
  5. Find the backup schedule and click Query Backup Set in the Actions column.
    Query a backup set
  6. In the Query Backup data message, click OK.
    The Query Backup data message
  7. In the left-side navigation pane of the Data Lake Analytics page, click Execute. On the Execute page, DLA automatically creates the database table schema of the DBS full backup set in the object list on the left side. Enter an SQL statement in the window and click Sync Execute(F8) to query the backup set.