Patent ID: 7814057

Claim:
A system that facilitates page-level data restore in a database, comprising computer readable memory having stored thereon the following components: a monitoring component that automatically detects one or more corrupt data values in a data page by a classifier automatically detecting according to predetermined criteria when to initiate a page restore; a backup component that generates backup copies of a data page, the data page being approximately 8 kilobytes of data in size and wherein the backup copies of the data page are created by backing up 2 kilobyte sections of the data page so that page level or partial page level restores can be accomplished thereby facilitating database restores accomplished without taking the database offline, in a memory upon a modification to the data page and generates update logs that store information related to page updates between backup copies, and restores a corrupt data page in the data base with a most recent uncorrupted backup copy of the data page by reading backup snapshots in a reverse chronological order from the corrupting event until the most recent uncorrupted backup copy is identified, replacing the corrupt page in the database with the most-recent uncorrupted backup copy, and modifying the most-recent uncorrupted backup copy to restore the database, the most-recent uncorrupted copy is modified according to update information obtained by traversing in a forward direction a log that records update events for the most recent uncorrupted copy subsequent to generation of the copy but prior to a next back up copy up until a point at which corruption occurred, wherein the backup component generates a first backup copy of the data page upon an indication that an update to the page is imminent, and wherein the first backup copy is generated before the modification; an update log that records page modification events; and wherein the backup component generates subsequent backup copies of the data page at predetermined intervals and truncates the update log upon generation of a subsequent backup copy and resumes the log to generate a new log segment that is associated with the subsequent backup copy.