Operations Management

Point-in-Time Recovery

English

Overview

A feature for restoring data to its state at any given point in time.

Details

A feature that combines a full backup with transaction logs to restore data to its state at any arbitrary point in time. Because it can roll back to a specific second right before an incident -- like the moment just before last night's batch job wrote bad data -- its biggest advantage is recovering legitimate changes made right up until the failure, which a full backup alone would lose.

More Database terms