Patent · US Active

Point in time database restore from storage snapshots

US9558078B2 · kind B2 · utility

123Cited by

167References

23Claims

0Family size

Assignee

MICROSOFT TECHNOLOGY LICENSING, LLC · US

Inventors

Kevin Farlee · Maple Valley, US
Lin Chan · Bellevue, US
Andrew Cherry · Kirkland, US

Key dates

Filing date	Oct 28, 2014
Grant date	Jan 31, 2017
Priority date	—
Expiry date	Jan 31, 2035

Classification

Technology area (CPC G)Physics
CPC primaryG06F2201/84
WIPO fieldComputer technology
WIPO sectorElectrical engineering

Abstract

Archiving a database and point in time recovery of the database. A method includes taking a first snapshot of a database. The first snapshot of the database includes a first snapshot of the data in the data storage and a first snapshot of the log records in the log storage. The method further includes taking a second snapshot of the database. The second snapshot of the database includes a second snapshot of the data in data storage and a second snapshot of the log records. The method further includes restoring the database to a particular point by applying the first snapshot of the data in the data storage to the database, applying the first snapshot of the log records in the log storage to the database and applying a portion of the second snapshot of the log records in the log storage to the database.

Source: USPTO / EPO open patent data. Objective bibliographic and citation counts.