All Products
Search
Document Center

Restore the data of a single table

Last Updated: Jun 28, 2020

Database Backup (DBS) allows you to restore the data of a single table in a database. Generally, if any data is deleted by mistake, only the related table is affected, whereas the entire database instance is not affected. In this case, you can select a single table to restore to greatly reduce the recovery time objective (RTO).

Click here to get a one-month trial of DBS>>

How it works

DBS allows you to restore the data of a single table in a database. DBS backs up data by table. When you select a single table as the object to restore, DBS only obtains the backup data of the selected table. In addition, based on the log backup feature, DBS can restore an object to any time point accurate to seconds.1

Procedure

Create a backup schedule

Go to the DBS purchase page and purchase a DBS backup schedule. Alternatively, you can log on to the DBS console and click Create Schedule on the Backup Schedules page.

Configure the backup schedule

In the left-side navigation pane of the DBS console, click Backup Schedules. On the Backup Schedules page that appears, find the target backup schedule and click Configure Backup Schedule in the Actions column.
6

Configure the backup schedule, specify the full backup cycle, and then enable incremental backup.
7

Restore the database

After the full backup schedule is configured, go to the details page of the backup schedule. On the Configure Task page, click Restore Database. In the configuration wizard, specify the time point accurate to seconds to which you want to restore the data and select the table to restore. DBS will quickly restore the data of the table.

The following figure shows how to select a single table for which you want to restore the data.
4

The following figure shows how to specify the time point accurate to seconds for the restore task. Note that you need to specify a time point within the available time range.
5