An enterprise network storage server experiences severe database corruption on a Thursday morning. To recover system functionality with zero data loss, the network team must execute a restoration plan. The organization's backup policy includes a weekly full backup performed every Sunday at 00:00, daily differential backups taken at 23:00, and continuous transaction logging. In what correct chronological order should the administrator execute the restoration steps?
- 1Restore the baseline full backup image from Sunday.
- 2Apply the single most recent differential backup from Wednesday evening.
- 3Replay the uncommitted transaction logs generated between Wednesday night and Thursday morning.
- 4Perform data integrity validation and re-enable operational network access.
Answer
The correct restoration sequence starts by restoring the full backup from Sunday, applying the latest differential backup from Wednesday night, replaying the transaction logs up to the moment of failure on Thursday morning, and completing post-restoration data integrity checks before reconnecting network services.
When executing a disaster recovery plan involving full and differential backups, the baseline full backup (Sunday) must be restored first. Next, because differential backups accumulate all changes since the previous full backup, only the latest differential backup (Wednesday) needs to be applied. Point-in-time transaction logs are then replayed to bring data up to the exact moment of failure on Thursday morning. Finally, verification is performed before resuming production network operations.
Step-by-Step Solution
Key Concept
Full and Differential Backup Restoration Sequence
Estimated Time:1m 30s