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.
Incremental and differential backups
From the course: Database Foundations: Administration
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Backup plans4m 29s
-
(Locked)
Create a PostgreSQL backup3m 31s
-
Use pg_dump in the Postgres container6m 12s
-
(Locked)
Restore a Postgres database10m 13s
-
(Locked)
Create a full SQL Server backup6m 42s
-
(Locked)
Restore a SQL Server database3m 42s
-
(Locked)
Incremental and differential backups4m 30s
-
(Locked)
Point-in-time restores4m 20s
-
(Locked)
-
-
-
-
-