point-in-time recovery

Restoring a database to its exact state at a chosen moment by loading a backup and replaying logged changes up to that moment.

In more detail

Point-in-time recovery, or PITR, starts from the last full backup and then replays the transaction log up to just before the failure or mistake. It can close the gap between nightly backups to minutes, which helps meet a tight recovery point objective. It is also how you undo a bad change, by stopping the replay just before it happened.

Example

Restore last night's full backup, then replay the transaction log to 14:36.

Related terms

Taught in

References

Certification courses