Data processing: database and file management or data structures – File or database maintenance – Database backup
Reexamination Certificate
2005-04-05
2010-10-12
Alam, Hosain T (Department: 2166)
Data processing: database and file management or data structures
File or database maintenance
Database backup
C707S650000, C707S648000
Reexamination Certificate
active
07814057
ABSTRACT:
Systems and methods are disclosed that facilitate providing page-level database restore functionality upon detection of a corruption event. Updates to a data page in a database can trigger generation of a snapshot of the data page, and an update log can be maintained that stores information related to page updates. Subsequent snapshots can be generated at predetermined intervals and can trigger truncation of a log segment and initiation of a new log segment. Upon detection of page corruption, a most-recent uncorrupt snapshot of the corrupt page can be identified, copied to the location of the corrupt page in the database, and modified according to the log segment associated with the uncorrupt snapshot to make the page current as of the corrupting event, all of which can be performed to restore the database without having to take the database offline.
REFERENCES:
patent: 5493649 (1996-02-01), Slivka et al.
patent: 5720026 (1998-02-01), Uemura et al.
patent: 5758359 (1998-05-01), Saxon
patent: 5978813 (1999-11-01), Foltz et al.
patent: 6076148 (2000-06-01), Kedem
patent: 6665815 (2003-12-01), Goldstein et al.
patent: 6785786 (2004-08-01), Gold et al.
patent: 6912631 (2005-06-01), Kekre et al.
patent: 7107486 (2006-09-01), Okada et al.
patent: 7246275 (2007-07-01), Therrien et al.
patent: 7290102 (2007-10-01), Lubbers et al.
patent: 2002/0147941 (2002-10-01), Gentile
patent: 2004/0167943 (2004-08-01), Margolus
patent: 2005/0015415 (2005-01-01), Garimella et al.
patent: 2005/0131966 (2005-06-01), Lou
patent: 2005/0132351 (2005-06-01), Randall et al.
patent: 2005/0182797 (2005-08-01), Adkins et al.
patent: 2005/0235016 (2005-10-01), Amano et al.
patent: 2006/0080362 (2006-04-01), Wagner et al.
Ann L. Chervenak, Vivekanand Vellanki, Zachary Kurmas, Protecting File Systems: A Survey of Backup Techniques, GA Tech University, p. 17-32.
Kathuria Vishal
Kodavalla Hanumantha R
Oks Artem A
Rajan Rajeev B
Schmidt Steven R
Alam Hosain T
Microsoft Corporation
Ng Amy
Workman Nydegger
LandOfFree
Page recovery using volume snapshots and logs does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Page recovery using volume snapshots and logs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Page recovery using volume snapshots and logs will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4196762