Backup and Restore

Backup Readiness

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

2026-11-09 12:52 generated
Reset
Readiness score0
RPO tierStandard
Backup risks23
Critical23
Affected servers4
msdb gaps0
Readiness gauge0 / 100
0
Risk mix23 databases
Critical
23
High
0
msdb gaps
0
Affected serverstop risk count
TESTSRV_2.DBNEXIA.COM
7
TESTSRV_3.DBNEXIA.COM
7
TESTSRV_1.DBNEXIA.COM
7
TESTSRV_5.DBNEXIA.COM
2
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 queue 23 of 23 databases
Risk Server Database Recovery Last full Last diff Last log Evidence Recommended action Owner / SLA
2054 TESTSRV_2.DBNEXIA.COM DOM_DreamStone_5722 FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_DreamStone_5722' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_2.DBNEXIA.COM DOM_ForestEcho_B4A4 FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_ForestEcho_B4A4' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_2.DBNEXIA.COM DOM_ForestSky_5A7D FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_ForestSky_5A7D' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_2.DBNEXIA.COM DOM_ShadowRiver_9AF6 FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_ShadowRiver_9AF6' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_2.DBNEXIA.COM DOM_WhisperEcho_929E FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_WhisperEcho_929E' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_3.DBNEXIA.COM DOM_CrystalStone_911A FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_CrystalStone_911A' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_3.DBNEXIA.COM DOM_FlameCrystal_07F4 FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_FlameCrystal_07F4' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_3.DBNEXIA.COM DOM_MoonCrystal_16FD FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_MoonCrystal_16FD' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_3.DBNEXIA.COM DOM_ShadowMoon_946A FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_ShadowMoon_946A' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

2054 TESTSRV_3.DBNEXIA.COM DOM_ShadowOcean_4486 FULL 2026-09-27 02:00 - 2026-09-27 22:00 FULL 43d ago, LOG 1022h ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DOM_ShadowOcean_4486' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 2054/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_2.DBNEXIA.COM DBAChaos SIMPLE 2026-09-27 02:00 - - FULL 43d ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'DBAChaos' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_2.DBNEXIA.COM dbNexia_db SIMPLE 2026-09-27 02:00 - - FULL 43d ago Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO. DBA, today
DBA assessment

database 'dbNexia_db' on TESTSRV_2.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_3.DBNEXIA.COM DBAChaos SIMPLE 2026-09-27 02:00 - - FULL 43d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DBAChaos' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_3.DBNEXIA.COM dbNexia_db SIMPLE 2026-09-27 02:00 - - FULL 43d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'dbNexia_db' on TESTSRV_3.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_5.DBNEXIA.COM DBAChaos SIMPLE 2026-09-27 02:00 - - FULL 43d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DBAChaos' on TESTSRV_5.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

1032 TESTSRV_5.DBNEXIA.COM dbNexia_db SIMPLE 2026-09-27 02:00 - - FULL 43d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'dbNexia_db' on TESTSRV_5.DBNEXIA.COM has a full backup, but it is 43.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 1032/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

566 TESTSRV_1.DBNEXIA.COM DOM_BlossomWhisper_FDD3 FULL 2026-10-28 02:00 - 2026-10-28 22:00 FULL 12d ago, LOG 278h ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DOM_BlossomWhisper_FDD3' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 566/100.

Recommended DBA action

Run or repair the full-backup job for DOM_BlossomWhisper_FDD3. 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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

566 TESTSRV_1.DBNEXIA.COM DOM_DreamBlossom_D66E FULL 2026-10-28 02:00 - 2026-10-28 22:00 FULL 12d ago, LOG 278h ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DOM_DreamBlossom_D66E' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 566/100.

Recommended DBA action

Run or repair the full-backup job for DOM_DreamBlossom_D66E. 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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

566 TESTSRV_1.DBNEXIA.COM DOM_ForestDream_BD6D FULL 2026-10-28 02:00 - 2026-10-28 22:00 FULL 12d ago, LOG 278h ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DOM_ForestDream_BD6D' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 566/100.

Recommended DBA action

Run or repair the full-backup job for DOM_ForestDream_BD6D. 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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

566 TESTSRV_1.DBNEXIA.COM DOM_ShadowWhisper_67B1 FULL 2026-10-28 02:00 - 2026-10-28 22:00 FULL 12d ago, LOG 278h ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DOM_ShadowWhisper_67B1' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 566/100.

Recommended DBA action

Run or repair the full-backup job for DOM_ShadowWhisper_67B1. 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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

566 TESTSRV_1.DBNEXIA.COM DOM_ThunderMoon_622B FULL 2026-10-28 02:00 - 2026-10-28 22:00 FULL 12d ago, LOG 278h ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DOM_ThunderMoon_622B' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 566/100.

Recommended DBA action

Run or repair the full-backup job for DOM_ThunderMoon_622B. 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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

288 TESTSRV_1.DBNEXIA.COM DBAChaos SIMPLE 2026-10-28 02:00 - - FULL 12d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'DBAChaos' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 288/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

288 TESTSRV_1.DBNEXIA.COM dbNexia_db SIMPLE 2026-10-28 02:00 - - FULL 12d ago Review backup policy and document restore-readiness status. DBA
DBA assessment

database 'dbNexia_db' on TESTSRV_1.DBNEXIA.COM has a full backup, but it is 12.5 days old and the policy is 7 day(s).

Operational impact

Restore can start only from that older baseline unless a newer valid full backup exists outside visible msdb evidence. Risk score 288/100.

Recommended DBA action

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.

Success criteria

The Last full value should move to the new finish time and this row should disappear or downgrade after refresh.

Action plan12 prioritized
P1
TESTSRV_2.DBNEXIA.COM / DOM_DreamStone_5722

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / DOM_ForestEcho_B4A4

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / DOM_ForestSky_5A7D

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / DOM_ShadowRiver_9AF6

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / DOM_WhisperEcho_929E

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_3.DBNEXIA.COM / DOM_CrystalStone_911A

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_3.DBNEXIA.COM / DOM_FlameCrystal_07F4

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_3.DBNEXIA.COM / DOM_MoonCrystal_16FD

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_3.DBNEXIA.COM / DOM_ShadowMoon_946A

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_3.DBNEXIA.COM / DOM_ShadowOcean_4486

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / DBAChaos

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

DBA, today
P1
TESTSRV_2.DBNEXIA.COM / dbNexia_db

Inspect the first full-backup job or destination error, repair the chain, create a new successful full backup, verify the media and complete an isolated restore test against the required RPO/RTO.

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.