Microsoft Technology Licensing, LLC

Microsoft Corporation

Gregory A Smith

Jakub Kulesza

Michael James Zwilling

Peter Byrne

Rajeev Bashyam Rajan

Mark Wistrom

Shashikant Brijmohan Khandelwal

Steven R Schmidt

Jeffrey A East

Mark S Wistrom

Shashikant B Khandelwal

Michael J Zwilling

Rajeev B Rajan

The present invention relates to a system and method of data restoration, for instance, after the occurrence of a user error. In particular, snapshot database can be maintained that stores a copy of database data. The snapshot database does not have to store a complete copy of all data on a source database, but rather shares data that is common to both but not necessarily identical. If an error occurs on the primary database then the database can be reverted back to a point in time prior to the error by replacing source database files with snapshot files. Additionally, an undo component can be employed in conjunction with the snapshot to approach an error to a finer grained point in time. In brief, the present invention can restore a database much faster and simpler, while utilizing less space and resources than conventional data restoration technologies.

Database data recovery system and method

To avoid possible data corruption resulting from restoring data to a database from a backup set that is not valid for the database, attempted restore operations are intercepted before they are performed. The backup set is examined to determine whether it was created from the same recovery fork on which the database resides or an descendant of that recovery fork. The backup set is only allowed to be applied to the database if the backup set was created from one of these recovery forks. If not, the backup set is not allowed to be applied to the database.

Backup and restoration of data in an electronic database

Growing community of inventors

Carnation, WA, United States of America

Gregory A Smith