Restore Points

Restore Point Mistake

Choosing an earlier target can leave a needed log record out.

highlighted = computed this step

Restore point mistake

Choose an earlier target and a needed record stays out. The diagrams show the difference directly.

early target misses record\text{early target misses record}

Compare two targets

The early target applies 1 record. The intended target applies 2 records.

early applied=1\text{early applied}=1

Backup and restore-point examples are tiny finite replay models; cloud products, backup strategy, RPO/RTO, encryption, compliance, performance, and runbooks are out of scope.

Early restore point: backup snapshotitemvalueA10B20 log after backuppositemvalue1A112B253A13 restore point factsfactvaluetarget1appliedCount1skippedCount2changedCount1targetIsBackupnotargetInLogyes applied log recordspositemvalue1A11 skipped log recordspositemvalue2B253A13 restored stateitemvalueA11B20 changed itemsitembeforeafterA1011
Intended restore point: backup snapshotitemvalueA10B20 log after backuppositemvalue1A112B253A13 restore point factsfactvaluetarget2appliedCount2skippedCount1changedCount2targetIsBackupnotargetInLogyes applied log recordspositemvalue1A112B25 skipped log recordspositemvalue3A13 restored stateitemvalueA11B25 changed itemsitembeforeafterA1011B2025

Name the miss

The early restore point misses 1 record that the intended target includes.

missed=1\text{missed}=1

Summary

The mistake is visible because applied and skipped records are recomputed for each target.

compare targets\text{compare targets}