A server hosts a database that requires nightly backups. The backup strategy uses a full backup every Sunday and differential backups on other days. On Wednesday, the server fails. Which backup sets are required to restore to the most recent state?
Trap 1: Last full backup and all differential backups since Sunday
Differential backups are cumulative, so only the most recent one is needed; applying all would be redundant but not harmful, though unnecessary.
Trap 2: Last full backup only
A full backup alone would restore data only up to Sunday, losing all changes made on Monday, Tuesday, and Wednesday.
Trap 3: Last full backup and all incremental backups since Sunday
This would be correct for an incremental strategy, but the scenario uses differential backups, not incremental.
- A
Last full backup and all differential backups since Sunday
Why wrong: Differential backups are cumulative, so only the most recent one is needed; applying all would be redundant but not harmful, though unnecessary.
- B
Last full backup only
Why wrong: A full backup alone would restore data only up to Sunday, losing all changes made on Monday, Tuesday, and Wednesday.
- C
Last full backup and the latest differential backup
This restores the database to the state at the time of the last differential, which includes all changes since Sunday.
- D
Last full backup and all incremental backups since Sunday
Why wrong: This would be correct for an incremental strategy, but the scenario uses differential backups, not incremental.