Join Martin Guidry for an in-depth discussion in this video Differential backups, part of Microsoft SQL Server 2014: Backup and Recovery.
- [Voiceover] In this section,…we'll look at differential backups.…In SQL Server, a differential backup…only captures the data that has changed…since the last full backup.…In other words, it is the difference between…the current time and the last full backup.…Differential backups are usually quicker than full backups,…because simply you are backing up less data.…So if you have a 200 gigabyte database,…to take a full backup of it would be…approximately 200 gigabytes.…
But let's say hypothetically…only 10% of that data has changed…since the last full backup,…if we do a differential backup we would only backup…that 10%, or approximately 20 megabytes.…So that should happen much quicker.…However, using differential backups…does result in a more complex restore process.…Let's look at that restore sequence.…If you have done a differential backup,…then when it comes time to restore…you would first restore the full backup,…the most recent full backup,…then you would restore the most recent differential backup.…
And then, if you are backing up logs,…
- Types of backups
- Media sets and backups
- Performing a basic backup using the GUI or command line
- Performing a basic restore using the GUI or command line
- Backing up and restoring logs
- Doing partial backup and restores
- Automating backups
- Using encryption and compression
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
SQL Server 2014: Installation and Administrationwith Ron Davis3h 40m Intermediate
Migrating Access Databases to SQL Serverwith Adam Wilbert2h 38m Intermediate
1. Backups in General
4. Partial Backups and Restores
5. Other Backup Topics
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.