Question

Difficulty: MediumBusiness Continuity and Disaster Recovery

A critical network management server experiences a hardware controller failure on Wednesday at 11:15 AM. The administrator must restore the system to the most recent operational state prior to the crash. The organization's backup schedule consists of a full backup executed every Sunday at 00:00, daily incremental backups executed Monday and Tuesday at 23:00, and hourly transaction log backups executed on the hour. Which of the following procedures describes the correct restoration sequence required to recover the server with minimal data loss?

  1. Restore the Sunday full backup, apply the Monday and Tuesday incremental backups sequentially, and then apply the Wednesday hourly transaction log backups from 01:00 through 11:00.Answer
  2. B
    Restore the Sunday full backup, skip the Monday incremental backup, apply the Tuesday incremental backup, and then apply the Wednesday 11:00 transaction log backup.
  3. C
    Restore only the Tuesday incremental backup followed by the Wednesday hourly transaction log backups up to 11:00.
  4. D
    Restore the Sunday full backup and apply only the Wednesday 11:00 transaction log backup.

Answer

Restore the Sunday full backup, apply the Monday and Tuesday incremental backups sequentially, and then apply the Wednesday hourly transaction log backups from 01:00 through 11:00.
Restoring an incremental backup strategy requires starting with the last full backup and sequentially applying every single incremental backup executed since that full backup. To achieve the Recovery Point Objective (RPO) nearest to the 11:15 AM outage, all hourly transaction log backups created on Wednesday up to 11:00 must then be applied in order.

Step-by-Step Solution

1
Identify the backup strategy type and baseline requirement.
The backup schedule utilizes incremental backups, which require the baseline full backup from Sunday 00:00.
Incremental backups rely on previous full and incremental sets to maintain cumulative file state changes.
2
Determine the chronological order of daily incremental backups.
The Monday 23:00 and Tuesday 23:00 incremental backups must both be applied in exact chronological order.
Unlike differential backups, incremental backups only clear the archive bit for data modified since the previous incremental backup.
3
Apply point-in-time transaction log backups to reach the time nearest to the outage.
Apply hourly transaction log backups from Wednesday 01:00 through 11:00.
This restores granular changes made throughout Wednesday morning prior to the 11:15 AM controller failure.

Key Concept

Incremental Backup Restoration Mechanics
Rate this question