Data processing: database and file management or data structures – Database design – Data structure types
Reexamination Certificate
2005-08-15
2009-12-22
Alam, Hosain T (Department: 2166)
Data processing: database and file management or data structures
Database design
Data structure types
C707S793000, C707S793000
Reexamination Certificate
active
07636741
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.
REFERENCES:
patent: 5307481 (1994-04-01), Shimazaki et al.
patent: 5966706 (1999-10-01), Biliris et al.
patent: 6205449 (2001-03-01), Rastogi et al.
patent: 6772309 (2004-08-01), Ohr et al.
patent: 6799189 (2004-09-01), Huxoll
patent: 6877016 (2005-04-01), Hart et al.
patent: 6883112 (2005-04-01), Maeda et al.
patent: 7177993 (2007-02-01), Kiselev et al.
patent: 7254683 (2007-08-01), Burton et al.
patent: 2003/0097533 (2003-05-01), Maeda et al.
patent: 2004/0002975 (2004-01-01), Scardo et al.
patent: 2004/0030721 (2004-02-01), Kruger et al.
patent: 2004/0098425 (2004-05-01), Wiss et al.
patent: 2004/0215998 (2004-10-01), Buxton et al.
patent: 2005/0055559 (2005-03-01), Bucher
patent: 2005/0071391 (2005-03-01), Fuerderer et al.
patent: 2007/0174583 (2007-07-01), Shinkai et al.
patent: 2 273 180 (1994-06-01), None
Brown, Eric., “An Overview of SQL Server 2005 Beta 2 for the Database Administrator”,Microsoft® Tech Net, Microsoft SQL Server TechCenter, Jul. 17, 2004, http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/sqlydba.mspx, 14 pages.
Talmage, Ron., “Split-Mirror Backup and Restore”, SQL Server Magazine,Microsoft® Tech Net, Microsoft SQL Server TechCenter, Updated May 31, 2002, http://www.microsoft.com/technet/prodtechnol/sql/2005/maintain/spltmirr.mspx, 6 pages.
Remote Data Backup-Online Backup Plan for Automatic Internet Backup. A Web Backup., http://www.remotedatabackups.com, Aug. 13, 2005, 2 pages.
Kulesza Jakub
Rajan Rajeev B.
Schmidt Steven R.
Alam Hosain T
Microsoft Corporation
Ng Amy
Woodcock & Washburn LLP
LandOfFree
Online page restore from a database mirror does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Online page restore from a database mirror, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Online page restore from a database mirror will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4130538