Restore chain stateevidence outcome
0review
16broken
0unknown
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.
Readiness score0
RPO tierStandard
Backup risks16
Critical16
Affected servers3
msdb gaps0
Readiness gauge0 / 100
0
Risk mix16 databases
Affected serverstop risk count
Action priority12 open
Readiness checkpointsRPO/RTO model
Fresh full backup
Valid log chain
msdb evidence visible
Restore test owned
Restore readiness model5 policy checks
Required for every database
Creates the base restore point and resets exposure from missing full history.Required for FULL and BULK_LOGGED recovery
Controls RPO and protects the log chain from growing unchecked.Recommended for large databases
Reduces restore time when full backups are large.Required for trusted readiness
Without msdb history the app must show a visibility gap, not a false green status.Required outside SQL telemetry
Fresh backups are not enough; restore success and duration need proof.
Readiness queue
16 of 16 databases
| Risk | Server | Database | Recovery | Last full | Last diff | Last log | Evidence | Recommended action | Owner / SLA |
|---|---|---|---|---|---|---|---|---|---|
| 808 | TESTSRV_2.DBNEXIA.COM | DOM_DreamStone_5722 | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_DreamStone_5722' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_DreamStone_5722. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_2.DBNEXIA.COM | DOM_ForestEcho_B4A4 | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ForestEcho_B4A4' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_ForestEcho_B4A4. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_2.DBNEXIA.COM | DOM_ForestSky_5A7D | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ForestSky_5A7D' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_ForestSky_5A7D. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_2.DBNEXIA.COM | DOM_ShadowRiver_9AF6 | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ShadowRiver_9AF6' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_ShadowRiver_9AF6. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_2.DBNEXIA.COM | DOM_WhisperEcho_929E | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_WhisperEcho_929E' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_WhisperEcho_929E. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_3.DBNEXIA.COM | DOM_CrystalStone_911A | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_CrystalStone_911A' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_CrystalStone_911A. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_3.DBNEXIA.COM | DOM_FlameCrystal_07F4 | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_FlameCrystal_07F4' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_FlameCrystal_07F4. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_3.DBNEXIA.COM | DOM_MoonCrystal_16FD | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_MoonCrystal_16FD' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_MoonCrystal_16FD. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_3.DBNEXIA.COM | DOM_ShadowMoon_946A | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ShadowMoon_946A' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_ShadowMoon_946A. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 808 | TESTSRV_3.DBNEXIA.COM | DOM_ShadowOcean_4486 | FULL | 2026-09-27 02:00 | - | 2026-09-27 22:00 | FULL 17d ago, LOG 400h ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ShadowOcean_4486' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 808/100. Recommended fix
Run or repair the full-backup job for DOM_ShadowOcean_4486. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_2.DBNEXIA.COM | DBAChaos | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DBAChaos' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for DBAChaos. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_2.DBNEXIA.COM | dbNexia_db | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'dbNexia_db' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for dbNexia_db. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_3.DBNEXIA.COM | DBAChaos | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'DBAChaos' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for DBAChaos. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_3.DBNEXIA.COM | dbNexia_db | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for dbNexia_db. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_5.DBNEXIA.COM | DBAChaos | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'DBAChaos' on TESTSRV_5.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for DBAChaos. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
| 408 | TESTSRV_5.DBNEXIA.COM | dbNexia_db | SIMPLE | 2026-09-27 02:00 | - | - | FULL 17d ago | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_5.DBNEXIA.COM has a full backup, but it is 17.5 days old and the policy is 7 day(s). Impact
Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 408/100. Recommended fix
Run or repair the full-backup job for dbNexia_db. If external backup evidence is shown, validate that the external chain is SQL-aware and restorable, then either expose that evidence or adjust policy deliberately. Verify
The Last full value should move to the new finish time and this row should disappear or downgrade after refresh. |
|||||||||
Action plan12 prioritized
TESTSRV_2.DBNEXIA.COM / DOM_DreamStone_5722
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / DOM_ForestEcho_B4A4
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / DOM_ForestSky_5A7D
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / DOM_ShadowRiver_9AF6
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / DOM_WhisperEcho_929E
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_3.DBNEXIA.COM / DOM_CrystalStone_911A
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_3.DBNEXIA.COM / DOM_FlameCrystal_07F4
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_3.DBNEXIA.COM / DOM_MoonCrystal_16FD
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_3.DBNEXIA.COM / DOM_ShadowMoon_946A
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_3.DBNEXIA.COM / DOM_ShadowOcean_4486
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / DBAChaos
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_2.DBNEXIA.COM / dbNexia_db
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today