Online page restore from a database mirror

• US 20070038682A1
• Filed: 08/15/2005
• Published: 02/15/2007
• Est. Priority Date: 08/15/2005
• Status: Active Grant

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Rajan, Rajeev, Kulesza, Jakub, Schmidt, Steven
• Granted Patent: US 7,636,741 B2
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 11/1469 Backup restoration techniques
• CPC Class Codes: G06F 11/2056 by mirroring
• CPC Class Codes: G06F 2201/80 Database-specific techniques
• CPC Class Codes: Y10S 707/99938 Concurrency, e.g. lock management in shared database
• CPC Class Codes: Y10S 707/99953 Recoverability

Abstract

A set of servers takes advantage of the existing data redundancy of a mirrored database to restore page corruptions. The page restore may occur with none of the time and/or administration costs of a restore from backup media and without the data loss associated with repair. Online page restore from a database mirror can be initiated and performed by the computer system automatically upon corruption detection. An entire file or database instead of an individual page or set(s) of pages can be restored. The mechanism can be used both to restore corrupt pages on the principal server from a mirror, or corrupt pages on a mirror from the principal server. Online page restore from a database mirror enables page data recovery without the need to find/load/scan through and apply data and log backups, allowing efficient and potentially automatic data recovery.

Claims

1. A system for restoring information comprising:

a module adapted to restoring corrupted information in a first database from corresponding uncorrupted information in a second database comprising;

detecting the corrupted information in the first database, wherein all information stored in the first database except for the corrupted information remains accessible;

sending a request to the second database for the uncorrupted information corresponding to the corrupted information in the first database; and

updating the first database with the uncorrupted information from the second database.

2. The system of claim 1, wherein the first database is a mirror database and the second database is a principal database.

3. The system of claim 1, wherein the first database is a principal database and the second database is a mirror database.

4. The system of claim 3, wherein the mirror database is a first mirror database of a plurality of mirror databases.

5. The system of claim 4, wherein the first mirror database is selected based on currency.

6. The system of claim 1, wherein the module comprises logic adapted to automatically restore the corrupted information from the second database upon detection of the corrupted information.

7. The system of claim 1, wherein the second database serves queries directed to the corrupted information in the first database.

8. The system of claim 1, wherein the corrupted information comprises a page of the first database, a set of pages of the first database or the first database.

9. A method for restoring corrupted information stored in a first database comprising:

in response to detecting the corrupted information in the first database, initiating restoration of the corrupted information without human intervention, the first database remaining accessible except for a portion of the first database on which is stored the corrupted information;

sending a request for a page or a set of pages to a second database, the page or the set of pages comprising uncorrupted information in the second database corresponding to the corrupted information in the first database;

receiving the corresponding uncorrupted information from the second database and applying the corresponding uncorrupted information to the first database.

10. The method of claim 9, further comprising:

sending a page identifier or a range of page identifiers and a log sequence number associated with a point in time at which the corrupted information was detected to the second database.

11. The method of claim 9, further comprising serving requests directed to the corrupted information in the first database from the second database.

12. The method of claim 9, further comprising selecting the second database based on currency or on response time.

13. The method of claim 9, further comprising persisting the uncorrupted information in the first database.

14. The method of claim 9, wherein the second database is a first mirror database of a plurality of mirror databases.

15. The method of claim 14, wherein load balancing is performed by sending to the first mirror database a first request for a first range of pages to be restored to the first database and by sending to a second mirror database of the plurality of mirror databases a second request for a second range of pages to be restored to the first database.

16. A computer-readable medium comprising computer-executable instructions for:

detecting corrupted information in a first database, the first database comprising a principal database;

receiving user input comprising at least one of;

a page identifier of a page of the principal database to restore, the page comprising a portion of the first database on which the corrupted information is stored, a mirror database to which a request for a corresponding page of the mirror database identified by the page identifier of the user input;

identifying the mirror database and initiating restoration of the corrupted information without human intervention, the first database remaining accessible except for the page of the first database on which is stored the corrupted information;

sending a request for a page or a set of pages to a second database, the page or set of pages comprising uncorrupted information in the second database corresponding to the corrupted information of the first database;

receiving the corresponding uncorrupted information from the second database and applying the uncorrupted information to the first database.

17. The computer-readable medium of claim 16 comprising further computer-executable instructions for:

persisting the uncorrupted information in the first database.

18. The computer-readable medium of claim 16, comprising further computer-executable instructions for:

selecting the second database based on currency of the second database, the second database comprising a first mirror database of a plurality of mirror databases associated with the first database.

19. The computer-readable medium of claim 16, comprising further computer-executable instructions for:

selecting the second database based on response time of the second database, the second database comprising a first mirror database of a plurality of mirror databases associated with the first database.

20. The computer-readable medium of claim 16, comprising further computer-executable instructions for:

load balancing the restoring of the corrupted information by sending a first range of page numbers to a first mirror and a second range of page numbers to a second mirror.