System and method for a consistency check of a database backup
First Claim
1. A method for performing a consistency check on a database backup, the method comprising:
- generating a list of pages to retrieve from a database backup;
retrieving the pages in the list by reading the database backup;
creating a database view from the database backup;
wherein the database view requires less memory space than the database contained in the database backup;
copying a transaction log and the retrieved pages into the database view;
recovering the database view to a transaction consistent state; and
performing a consistency check on the database backup by reading all database pages from one of the database backup and the database view.
2 Assignments
0 Petitions
Accused Products
Abstract
A method for performing a consistency check on a database backup of a database is performed without requiring a full recovery of the original database from the database backup. Instead, a database view may be used as a smaller storage requirement tool for providing a transaction-consistent view of portions of an existing full database backup. The database view, in combination with the database backup and transaction log, contains all the information necessary to perform a consistency check on the database backup without a full reconstitution of the original database from the database backup. The consistency check may be run on the database view along with the database backup to verify the integrity of the full database backup to add improved reliability to a database recovery scheme.
-
Citations
35 Claims
-
1. A method for performing a consistency check on a database backup, the method comprising:
-
generating a list of pages to retrieve from a database backup; retrieving the pages in the list by reading the database backup; creating a database view from the database backup;
wherein the database view requires less memory space than the database contained in the database backup;copying a transaction log and the retrieved pages into the database view; recovering the database view to a transaction consistent state; and performing a consistency check on the database backup by reading all database pages from one of the database backup and the database view. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16)
-
-
17. A system comprising:
-
an input device for receiving at least one of database backup information and log transaction data; a processor having access to memory, the memory having instructions of a software component; and a software component, which when executed, performs a method comprising; generating a list of pages to retrieve from a database backup; retrieving the pages in the list by accessing the database backup; creating a database view from the database backup;
wherein the database view requires less memory space than the database contained in the database backup;copying a transaction log and the retrieved pages into the database view; recovering the database view to a transaction consistent state; and performing a consistency check on the database backup using the database backup and the transaction consistent database view. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24, 25, 26, 27)
-
-
28. A computer-readable medium having computer-executable instructions for performing a method of running a consistency check on a database backup, the method comprising:
-
generating a list of pages to retrieve from a database backup; retrieving the pages in the list by reading the database backup; creating a database view from the database backup;
wherein the database view requires less memory space than the database contained in the database backup;copying a transaction log and the retrieved pages into the database view; recovering the database view to a transaction consistent state; and performing a consistency check on the database backup by reading all database pages from one of the database backup and the database view. - View Dependent Claims (29, 30, 31, 32, 33, 34, 35)
-
Specification