Mid SQL

Differential Backup:?

  • A differential backup includes all the changes made since the last full backup.

It does not depend on other differential backups.

  • Advantages: Smaller than a full backup, and quicker to take compared to full

backups.

  • Disadvantages: Can become larger over time as more changes accumulate

between full backups.

  • Example: If the last full backup was taken on Monday, a differential backup

taken on Wednesday would include all changes since Monday.

More from SQL Server Tutorial

All questions for this course