An enterprise network administrator maintains a disaster recovery plan for an active database server. The backup schedule performs a full backup every Sunday at 01:00, daily differential backups every evening at 23:00 (Monday through Saturday), and incremental transaction log backups every two hours between 08:00 and 18:00 daily. On Thursday at 15:30, a primary storage failure occurs. Which sequence of backup sets must be restored to recover the server to its 14:00 Thursday point-in-time state with the fewest restoration operations?
- The Sunday full backup, the Wednesday differential backup, and the Thursday 08:00, 10:00, 12:00, and 14:00 incremental backups in chronological orderCevap
- BThe Sunday full backup, followed sequentially by the Monday, Tuesday, and Wednesday differential backups, and all Thursday incremental backups up to 14:00
- CThe Sunday full backup and every incremental backup taken sequentially from Monday morning through Thursday at 14:00
- DThe Sunday full backup, the Wednesday differential backup, and only the Thursday 14:00 incremental backup
Cevap
Restoring the Sunday full backup, the Wednesday differential backup, and the sequential Thursday incremental backups (08:00, 10:00, 12:00, and 14:00) provides the fastest, complete point-in-time recovery.
To achieve a point-in-time restore with the minimum number of steps, the restoration process begins with the last full backup (Sunday). The latest differential backup (Wednesday at 23:00) is applied next, which rolls all data forward to Wednesday night in one operation, superseding Monday and Tuesday differentials. Finally, because incremental backups record only changes since the last backup of any type, each incremental backup on Thursday (08:00, 10:00, 12:00, and 14:00) must be applied sequentially to recover up to 14:00.
Adım Adım Çözüm
Anahtar Kavram
Disaster recovery backup restoration sequences using full, differential, and incremental backup types