From the course: Database Foundations: Administration

Unlock the full course today

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

Incremental and differential backups

Incremental and differential backups

From the course: Database Foundations: Administration

Start my 1-month free trial

Incremental and differential backups

- [Instructor] In addition to making a full backup of everything the database contains, many RDBMS platforms have support for making partial or incremental backups. As a database grows in size from a few megabytes up to terabytes, gigabytes, and potentially, many petabytes of data, the costs associated with backing up all of that data, also increase. Not only do you need many multiples worth of available storage capacity, but the time required to make the backup copy can stretch out from seconds to hours, or even days. It's not uncommon to find that the length of time required for each backup to complete, exceeds the frequency at which you'd want to make them. Obviously, if you're trying to make a backup every hour and each backup takes a full day to complete, that's not a viable backup strategy. You'll be nearly a month behind schedule at the end of your very first day. The solution is to reduce the volume of data that…

Contents