Method and apparatus for restoring a table in a database

• US 8,874,519 B1
• Filed: 12/18/2007
• Issued: 10/28/2014
• Est. Priority Date: 12/18/2007
• Status: Active Grant

• Current Assignee: Veritas Technologies, LLC (Whitehouse Group Ltd.)
• Original Assignee: Symantec Corporation (NortonLifeLock Inc.)
• Inventors: Payne, Michael
• Primary Examiner(s): Hoang, Son T
• Application Number:
  US12/002,593
• Time in Patent Office: 2,506 Days
• Field of Search: None
• US Class Current: 707/640
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases

Abstract

A method and apparatus for restoring table data using one or more restoration commands, where the one or more restoration commands are generated at the time a backup of a database comprising the table data is created. The disclosed restoring of table data comprises identifying table data after completion of a backup process on the database and generating one or more commands for restoring the table data where the one or more restoration commands are generated prior to a request to restore the table data.

Claims

1. A method for restoring a table in a database comprising:

identifying a copy of first table data after completion of a backup process of the database, wherein

the database comprises at least a first table and a second table,

the first table data comprises data stored in the first table,

second table data comprises data stored in the second table,

the backup process produces a backup of the first table data,

the backup of the first table data comprises copies of a plurality of table data blocks,

the copies of the plurality of table data blocks comprise the copy of the first table data, and

the identifying identifies the copy of the first table data in the backup of the first table data; and

generating a command for restoring the first table data from the backup of the first table data, wherein

the command is generated prior to a detection of a request to restore the first table data and in response to completion of the backup process producing the backup of the first table data,

the command is configured to be executed in response to the detection of the request to restore the first table data without restoring the second table data, and the generating the command comprises;

accessing the copy of the first table data in the backup of the first table data, wherein the accessing is performed based on the identifying,

parsing a portion of the copy of the first table data, and

including the parsed portion of the copy of the first table data in the command.

2. The method of claim 1, wherein

the generating the command further comprises generating a script, and

the script comprises the command for restoring the first table data.

3. The method of claim 1, wherein the generating the command further comprises generating a Transact-SQL command for inserting the parsed portion of the copy of the first table data into the database.

4. The method of claim 1, wherein the generating the command further comprises accessing the portion of the copy of the first table data from within the backup.

5. The method of claim 4, wherein

the accessing the portion further comprises using address information associated with the portion of the copy of the first table data in the backup to access at least one file block in the backup, and

the at least one file block represents the portion of the copy of the first table data.

6. The method of claim 4, wherein the portion of the copy of the first table data is a row, and the parsing the portion of the copy of the first table data comprises parsing the row of the parsed portion of the copy of the first table data into at least one column.

7. The method of claim 6, wherein the including the parsed portion of the copy of the first table data comprises formatting the row of the parsed portion of the copy of the first table data into the command.

8. The method of claim 1, wherein the generating the command is performed prior to detection of an error in the database.

9. An apparatus for restoring a table in a database comprising:

a non-transitory computer-readable memory; and

a processor coupled to the non-transitory computer-readable memory, wherein the processor is configured to;

identify a copy of first table data in a backup image after completion of a backup process of the database, wherein

the backup image is associated with the database,

the database comprises at least a first table and a second table,

the first table data comprises data stored in the first table,

second table data comprises data stored in the second table,

the backup image comprises a copy of the first table data,

the backup image comprises copies of a plurality of table data blocks, and

the copies of the plurality of table data blocks comprise the copy of the first table data; and

generate a command for restoring the first table data from the backup image, wherein

the command is generated prior to detection of a request for restoring the first table data from the backup image and in response to completion of the backup process producing the backup image,

the command is generated by;

accessing the copy of the first table data in the backup image, wherein

the accessing is performed based on the identifying,

parsing a portion of the copy of the first table data, and

including the parsed portion of the copy of the first table data in the command, and

the command, when executed, restores the first table data without restoring the second table data.

10. The apparatus of claim 9, wherein the command is automatically executed upon detection of an error in the database.

11. The apparatus of claim 9, wherein the processor is further configured to generate a Transact-SQL command for inserting the first table data into the database.

12. The apparatus of claim 9, wherein the processor is further configured to access a row of the copy of the first table data from the backup image.

13. The apparatus of claim 9, wherein the processor is further configured to parse the portion of the copy of the first table data by parsing a row of the copy of the first table data into at least one column.

14. The apparatus of claim 13, wherein the processor is further configured to include the parsed portion of the copy of the first table data by formatting the row of the copy of the first table data into a Transact-SQL command.

15. The apparatus of claim 9, wherein the command is generated prior to detection of an error in the database.

16. A non-transitory computer-readable storage medium storing instructions executable by a processor, wherein the instructions, when executed, perform a method for restoring a table in a database comprising:

identifying a copy of first table data after completion of a backup process of the database, wherein

the database comprises at least a first table and a second table,

the first table data comprises data stored in the first table,

second table data comprises data stored in the second table,

the backup process produces a backup of the first table data,

the backup of the first table data comprises copies of a plurality of table data blocks,

the copies of the plurality of table data blocks comprise the copy of the first table data, and

the identifying identifies the copy of the first table data in the backup of the first table data; and

generating a command for restoring the first table data from the backup of the first table data, wherein

the command is generated prior to a detection of a request to restore the first table data and in response to completion of the backup process producing the backup of the first table data,

the command is configured to be executed in response to the detection of the request to restore the first table data without restoring the second table data, and the generating the command comprises;

accessing the copy of the first table data in the backup of the first table data, wherein the accessing is performed based on the identifying,

parsing a portion of the copy of the first table data, and

including the parsed portion of the copy of the first table data in the command.

17. The non-transitory computer-readable storage medium of claim 16, wherein the command is further configured to reinsert the copy of the first table data into the database.

18. The non-transitory computer-readable storage medium of claim 17, wherein the command is automatically executed in response to the detection of the request to restore the first table data.

19. The non-transitory computer-readable storage medium of claim 16, wherein the including the parsed portion of the copy of the first table data comprises generating a Transact-SQL command for inserting a row of the first table data into the database.

20. The non-transitory computer-readable storage medium of claim 16, wherein

the backup process stores the copy of the first table data in the backup of the first table data, and

the command accesses the copy of the first table data in the backup of the first table data.