Point in Time Recovery on a Database

摘要

Disclosed herein are system, method, and computer program product embodiments for providing point in time recovery on a database. An embodiment operates by determining that one or more values were written to one of a plurality of database nodes of a database as part of a write transaction. The one or more data pages to which the one or more values were written are copied to a storage location of a backup corresponding to the write transaction. The storage location of the one or more data pages in the backup are written to a location in a transaction log corresponding to the write transaction.

主权项

1. A computer-implemented method, comprising:
determining that one or more values were written to one of a plurality of database nodes of a database as part of a write transaction; determining one or more data pages of the database node to which the one or more values were written; copying the one or more data pages to a storage location of a backup corresponding to the write transaction; and writing the storage location to a location in a transaction log corresponding to the write transaction, wherein the transaction log includes a storage location of each of a plurality of consecutive write transactions to the database, wherein a restore of the database to an earlier point in time comprises a restore of the database to a point in time corresponding to one of the plurality of consecutive write transactions of the transaction log.