Page recovery using volume snapshots and logs

A method of backing up data in a database at a page level, comprising:

• detecting a modification to a data page in the database;
• generating a pre-modification backup copy of the data page;
• generating an update log that records update events to the data page subsequent to generation of the pre-modification copy;
• generating subsequent backup copies of the data page at predetermined intervals, each subsequent backup copy triggers a current log segment to be truncated and a new log segment to be generated.

A system that facilitates page-level restore in a database, comprising:

• means for detecting an imminent modification to a page in a database;
• means for generating a pre-modification snapshot copy of the page immediately prior to the detected modification;
• means for generating a log that records modifications to the page after the pre-modification snapshot;
• means for generating at least one subsequent snapshot copy of the page at a predetermined scheduled time;
• and
• means for truncating the log and initiating a subsequent log segment associated with the at least one subsequent snapshot copy.