Restoration Methods

Restoration Methods for Data Misoperations

There are many scenarios where data can be accidentally mishandled, such as deleting a table, database, or instance, overwriting the entire table, and deleting or modifying columns, rows, or data in a table by mistake. You can choose an appropriate data restoration method based on the site requirements.

**Table 1** Restoration methods for misoperations
Scenario	Restoration Method	Restoration Scope	Operation Guide
An instance is deleted by mistake.	Recycle bin: Locate the deleted instance in the recycle bin and rebuild the instance to restore it.	All databases and tables	Restoring Data of a Deleted Instance
An instance is deleted by mistake.	Instance backup: If a manual backup has been created before the instance is deleted, restore the instance on the Backups page.	All databases and tables	Restoring Data of a Deleted Instance
A database is deleted by mistake.	Use the database and table restoration method to restore the database.	All databases and tables Certain databases and tables	Restoring Data of Multiple Deleted Databases
A table is deleted by mistake.	Use the database and table restoration method to restore the table.	All databases and tables Certain databases and tables	Restoring Data of Deleted Tables
An entire table is overwritten, or the columns, rows, or data in a table is deleted or modified by mistake.	If more than 100,000 data records are accidentally mishandled, use the database and table restoration method to restore table data.	All databases and tables Certain databases and tables	Restoring Data of Deleted Tables