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).
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.
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.
Configure the backup schedule, specify the full backup cycle, and then enable incremental backup.
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.
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.