Backup & Restore Readiness

Recovery risk before restore day

Checks backup age, recovery model exposure and msdb backup visibility so teams can distinguish a clean backup state from missing evidence.

2026-06-21 05:32 generated
Readiness score0
RPO tierStandard
Backup risks23
Critical23
Affected servers5
msdb gaps0
Readiness gauge0 / 100
0
Risk mix23 databases
Critical
23
High
0
msdb gaps
0
Affected serverstop risk count
SERVER 1
7
SERVER 2
7
SERVER 3
7
SERVER 4
1
SERVER 5
1
Restore chain stateevidence outcome
0review
23broken
0unknown
Action priority12 open
P1
12
Readiness checkpointsRPO/RTO model
Fresh full backup Valid log chain msdb evidence visible Restore test owned
Restore readiness model5 policy checks
Full backup 7 days max age

Required for every database

Creates the base restore point and resets exposure from missing full history.
Log backup 24 hours max age

Required for FULL and BULK_LOGGED recovery

Controls RPO and protects the log chain from growing unchecked.
Differential backup Optional acceleration

Recommended for large databases

Reduces restore time when full backups are large.
msdb visibility Mandatory evidence

Required for trusted readiness

Without msdb history the app must show a visibility gap, not a false green status.
Restore test 90 days process target

Required outside SQL telemetry

Fresh backups are not enough; restore success and duration need proof.
Readiness queue23 databases
Risk Server Database Recovery Last full Last diff Last log Evidence Recommended action Owner / SLA
10608 SERVER 1 MAL_MAINT_DB SIMPLE 2025-04-04 12:38 - - FULL 442d ago Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
10608 SERVER 2 MAL_MAINT_DB SIMPLE 2025-04-04 12:38 - - FULL 442d ago Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
10608 SERVER 3 MAL_MAINT_DB SIMPLE 2025-04-04 12:38 - - FULL 442d ago Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 1 DOM_BlossomWhisper_FDD3 FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 1 DOM_DreamBlossom_D66E FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 1 DOM_ForestDream_BD6D FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 1 DOM_ShadowWhisper_67B1 FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 1 DOM_ThunderMoon_622B FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 2 DOM_DreamStone_5722 FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 2 DOM_ForestEcho_B4A4 FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 2 DOM_ForestSky_5A7D FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 2 DOM_ShadowRiver_9AF6 FULL - - - FULL missing, LOG missing Run full backup, verify job schedule and confirm the new backup row in msdb. DBA, today
210 SERVER 2 DOM_WhisperEcho_929E FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
210 SERVER 3 DOM_CrystalStone_911A FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
210 SERVER 3 DOM_FlameCrystal_07F4 FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
210 SERVER 3 DOM_MoonCrystal_16FD FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
210 SERVER 3 DOM_ShadowMoon_946A FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
210 SERVER 3 DOM_ShadowOcean_4486 FULL - - - FULL missing, LOG missing Review backup policy and document restore-readiness status. DBA
180 SERVER 1 MAL_MAINT_DB_old SIMPLE - - - FULL missing Review backup policy and document restore-readiness status. DBA
180 SERVER 2 MAL_MAINT_DB_old SIMPLE - - - FULL missing Review backup policy and document restore-readiness status. DBA
180 SERVER 3 MAL_MAINT_DB_old SIMPLE - - - FULL missing Review backup policy and document restore-readiness status. DBA
180 SERVER 4 MAL_MAINT_DB SIMPLE - - - FULL missing Review backup policy and document restore-readiness status. DBA
180 SERVER 5 MAL_MAINT_DB SIMPLE - - - FULL missing Review backup policy and document restore-readiness status. DBA
Action plan12 prioritized
P1
SERVER 1 / MAL_MAINT_DB

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 2 / MAL_MAINT_DB

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 3 / MAL_MAINT_DB

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 1 / DOM_BlossomWhisper_FDD3

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 1 / DOM_DreamBlossom_D66E

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 1 / DOM_ForestDream_BD6D

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 1 / DOM_ShadowWhisper_67B1

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 1 / DOM_ThunderMoon_622B

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 2 / DOM_DreamStone_5722

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 2 / DOM_ForestEcho_B4A4

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 2 / DOM_ForestSky_5A7D

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
P1
SERVER 2 / DOM_ShadowRiver_9AF6

Run full backup, verify job schedule and confirm the new backup row in msdb.

DBA, today
RPOSet log-backup thresholds to match the maximum accepted data loss for FULL/BULK_LOGGED databases.
RTOAdd restore-test evidence to your process so backup freshness is not mistaken for restore readiness.
Chain healthAny missing full/log history should become action work, not just a dashboard warning.