Systems and methods for automatic database or file system maintenance and repair

• US 20070073764A1
• Filed: 11/28/2006
• Published: 03/29/2007
• Est. Priority Date: 05/03/2004
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Oks, Artem, Kodavalla, Hanumantha, Sleeman, Martin
• Application Number:
  US11/605,184
• Publication Number:
  US 20070073764A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1402 Saving, restoring, recovering or retrying
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/1471 involving logging of persistent data for recovery
• CPC Class Codes: G06F 11/1474 in transactions G06F16/20 takes precedence
• CPC Class Codes: G06F 16/221 Column-oriented storage; Management thereof
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: G06F 2201/84 Using snapshots, i.e. a logical point-in-time copy of the data
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

The present invention relates generally to database and file system management and, more particularly, to automatic database and file system maintenance and repair to ensure data reliability. Various aspects of the present invention relate to responding and correcting data corruptions at a data page level for all data page types, as well as to recovery (including rebuild or restore operations) for various scenarios including, without limitation, index page corruptions (clustered and non-clustered), data page corruptions, and page corruptions in the log file.

Claims

1. A system for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said system comprising:

a subsystem for aborting said transaction and attempting a page level restoration; and

a subsystem for determining whether the page level restoration fails or is unavailable, further comprising;

a subsystem for attempting an index recovery when the failure is for an index page;

a subsystem for attempting a data page recovery when the failure is for a data page;

a subsystem for attempting an emergency repair when the failure is due to a log page error; and

a subsystem for attempting to restore the entire database when the failure is an unrecoverable error.

2. A method for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said method comprising:

aborting said transaction and attempting a page level restoration; and

if the page level restoration fails or is unavailable, then;

if the failure is for an index page, attempting an index recovery;

if the failure is for a data page, attempting a data page recovery;

if the failure is due to a log page error, attempting an emergency repair; and

if the failure is an unrecoverable error, attempting to restore the entire database.

3. A computer-readable medium comprising computer-readable instructions for resolving an error encountered by a query engine during a transaction to a corrupt data store attached to a database file system (DBFS), said computer-readable instructions comprising instructions for:

aborting said transaction and attempting a page level restoration; and

if the page level restoration fails or is unavailable, then;

if the failure is for an index page, attempting an index recovery;

if the failure is for a data page, attempting a data page recovery;

if the failure is due to a log page error, attempting an emergency repair; and

if the failure is an unrecoverable error, attempting to restore the entire database.