Consider a site that performs a full backup every Sunday, a cumulative backup every Wednesday, and delta backups on the other days:
The table shows which save sets are restored when you select a given restore date.
| Save Set | Day | Type | Restore These |
|---|---|---|---|
| 1 | Sunday | Full All data for all tables. |
1 |
| 2 | Monday | Delta Data that changed today. |
2, 1 |
| 3 | Tuesday | Delta Data that changed today. |
3, 2, 1 |
| 4 | Wednesday | Cumulative All changes since the full backup. |
4, 1 |
| 5 | Thursday | Delta Data that changed today. |
5, 4, 1 |
| 6 | Friday | Delta Data that changed today. |
6, 5, 4, 1 |
| 7 | Saturday | Delta Data that changed today. |
7, 6, 5, 4, 1 |