Point-in-time recovery

From Wikipedia, the free encyclopedia

Point-in-time recovery (PITR) in the context of computers involves systems, often databases, whereby an administrator can restore or recover a set of data or a particular setting from a time in the past.[1][2][3] Note for example Windows XP's capability to restore operating-system settings from a past date (for instance, before data corruption occurred). Time Machine for Mac OS X provides another example of point-in-time recovery.

Once PITR logging starts for a PITR-capable database, a database administrator can restore that database from backups to the state that it had at any time since.[1]

See also[edit]


  1. ^ a b Larsen, Gregory A. (2005-08-31). "Point in Time Recovery". DatabaseJournal.com. Retrieved 2020-10-06.
  2. ^ "MySQL :: MySQL Backup and Recovery :: 1.5 Point-in-Time (Incremental) Recovery". MySQL. 2020-09-18. Retrieved 2020-10-06.
  3. ^ "Overview of restoring an instance". Google Cloud. Retrieved 2020-10-06.

External links[edit]