Point-in-time recovery
From HandWiki
Revision as of 10:56, 9 July 2021 by imported>MainAI5 (url)
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
References
- ↑ 1.0 1.1 Larsen, Gregory A. (2005-08-31). "Point in Time Recovery". https://www.databasejournal.com/features/mssql/article.php/3530616/Point-in-Time-Recovery.htm.
- ↑ "MySQL :: MySQL Backup and Recovery :: 1.5 Point-in-Time (Incremental) Recovery". 2020-09-18. https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/point-in-time-recovery.html.
- ↑ "Overview of restoring an instance". https://cloud.google.com/sql/docs/postgres/backup-recovery/restore.
External links
- PostgreSQL Continuous Archiving and Point-in-Time Recovery (PITR)
- MySQL 8.0 Point-in-Time Recovery Using the Binary Log
 |  |
