Backup Readiness
Checks backup age, recovery model exposure and msdb backup visibility so teams can distinguish a clean backup state from missing evidence.
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.| 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. |
|||||||||
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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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, todayInspect 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