From the course: Database Foundations: Administration

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Point-in-time restores

Point-in-time restores

From the course: Database Foundations: Administration

Start my 1-month free trial

Point-in-time restores

“

- [Instructor] Full and incremental backup files are useful for recovering the database to the exact state that it was in when the backup was made. But what if something happens between backups and you need to restore to an arbitrary point in time? Well, the more advanced RDBMS platforms have a solution for this situation as well. The first thing we need to understand is that our relational databases are made up of two separate kinds of files on our discs. The data file stores the current state of your database. Whenever you create a new table or add a lot of data the data file is updated to reflect those changes. The second type of file that we have is called the transaction log. The log maintains a list of all the changes that are made to your database. You can think of the transaction log like the receipt tape that comes out of an old style adding machine. The log contains a sequential record of every change that's made…

Contents