Differential Backups
A differential backup records only the data that has changed since the last full backup of the same part of the data/same data files/same database subset. Usually, these backups are smaller and faster than full backups, but larger and longer than Transaction log backups. To restore a database, a differential backup requires only the last full backup as a prerequisite, and does not need any of the other differential or Transaction log backups performed between it and the last full backup. A differential backup is also faster to restore than a Transaction log backup because transactions do not need to be reprocessed.
Note: If a database is very active or if a long time has passed since the last full backup, a differential backup could take as long as a full backup.
For more information, see Differential Backup Timing.
|
Copyright © 2016
|
|