TABLE LEVEL DATABASE RESTORE IN A DATA STORAGE SYSTEM

摘要

The data storage system according to certain aspects can implement table level database restore. Table level database restore may refer to restoring a database table and its related data without restoring the entire database. The data storage system may use table metadata index to implement table level restore. A table metadata index may be created for each table, e.g., during a backup of the database. The table metadata index for a table can include any type of information for restoring the table and its related data. Some examples of the type of information included in the table metadata index include the following: container for the table, table backup location, system data, table index, table relationships, etc. Table metadata index can make the restoring of tables fast and efficient by packaging information that can be used to restore a table and its related data in an easily accessible manner.

主权项

1. A method of restoring a database table from secondary storage in a data storage system, comprising:
receiving instructions to restore a first one of a plurality of database tables from secondary storage to primary storage, wherein the plurality of database tables is associated with a database application executing on one or more client computing devices, and wherein a secondary copy of data associated with the database application is stored in the secondary storage and comprises data relating to the plurality of database tables; accessing a table metadata index associated with the first table, wherein the table metadata index comprises information for restoring the first table and its associated data; and restoring data relating to the first table from the secondary storage to the primary storage without restoring the entire secondary copy of the data associated with the database application.