Restore chain stateevidence outcome
0review
20broken
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 risks20
Critical20
Affected servers5
msdb gaps0
Readiness gauge0 / 100
0
Risk mix20 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
20 of 20 databases
| Risk | Server | Database | Recovery | Last full | Last diff | Last log | Evidence | Recommended action | Owner / SLA |
|---|---|---|---|---|---|---|---|---|---|
| 210 | TESTSRV_1.DBNEXIA.COM | DOM_BlossomWhisper_FDD3 | FULL | - | - | - | FULL missing, LOG missing | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_BlossomWhisper_FDD3' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_BlossomWhisper_FDD3. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_BlossomWhisper_FDD3 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_1.DBNEXIA.COM | DOM_DreamBlossom_D66E | FULL | - | - | - | FULL missing, LOG missing | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_DreamBlossom_D66E' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_DreamBlossom_D66E. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_DreamBlossom_D66E newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_1.DBNEXIA.COM | DOM_ForestDream_BD6D | FULL | - | - | - | FULL missing, LOG missing | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ForestDream_BD6D' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ForestDream_BD6D. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ForestDream_BD6D newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_1.DBNEXIA.COM | DOM_ShadowWhisper_67B1 | FULL | - | - | - | FULL missing, LOG missing | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ShadowWhisper_67B1' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ShadowWhisper_67B1. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ShadowWhisper_67B1 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_1.DBNEXIA.COM | DOM_ThunderMoon_622B | FULL | - | - | - | FULL missing, LOG missing | Run full backup, verify job schedule and confirm the new backup row in msdb. | DBA, today |
|
Meaning
database 'DOM_ThunderMoon_622B' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ThunderMoon_622B. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ThunderMoon_622B newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_2.DBNEXIA.COM | DOM_DreamStone_5722 | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_DreamStone_5722. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_DreamStone_5722 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_2.DBNEXIA.COM | DOM_ForestEcho_B4A4 | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ForestEcho_B4A4. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ForestEcho_B4A4 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_2.DBNEXIA.COM | DOM_ForestSky_5A7D | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ForestSky_5A7D. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ForestSky_5A7D newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_2.DBNEXIA.COM | DOM_ShadowRiver_9AF6 | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ShadowRiver_9AF6. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ShadowRiver_9AF6 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_2.DBNEXIA.COM | DOM_WhisperEcho_929E | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_WhisperEcho_929E. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_WhisperEcho_929E newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_3.DBNEXIA.COM | DOM_CrystalStone_911A | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_CrystalStone_911A. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_CrystalStone_911A newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_3.DBNEXIA.COM | DOM_FlameCrystal_07F4 | FULL | - | - | - | FULL missing, LOG missing | 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 no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_FlameCrystal_07F4. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_FlameCrystal_07F4 newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_3.DBNEXIA.COM | DOM_MoonCrystal_16FD | FULL | - | - | - | FULL missing, LOG missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'DOM_MoonCrystal_16FD' on TESTSRV_3.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_MoonCrystal_16FD. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_MoonCrystal_16FD newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_3.DBNEXIA.COM | DOM_ShadowMoon_946A | FULL | - | - | - | FULL missing, LOG missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'DOM_ShadowMoon_946A' on TESTSRV_3.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ShadowMoon_946A. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ShadowMoon_946A newer than 7 day(s). |
|||||||||
| 210 | TESTSRV_3.DBNEXIA.COM | DOM_ShadowOcean_4486 | FULL | - | - | - | FULL missing, LOG missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'DOM_ShadowOcean_4486' on TESTSRV_3.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is FULL. Risk score 210/100. Recommended fix
Run the full-backup job for DOM_ShadowOcean_4486. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for DOM_ShadowOcean_4486 newer than 7 day(s). |
|||||||||
| 180 | TESTSRV_1.DBNEXIA.COM | dbNexia_db | SIMPLE | - | - | - | FULL missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_1.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is SIMPLE. Risk score 180/100. Recommended fix
Run the full-backup job for dbNexia_db. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for dbNexia_db newer than 7 day(s). |
|||||||||
| 180 | TESTSRV_2.DBNEXIA.COM | dbNexia_db | SIMPLE | - | - | - | FULL missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_2.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is SIMPLE. Risk score 180/100. Recommended fix
Run the full-backup job for dbNexia_db. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for dbNexia_db newer than 7 day(s). |
|||||||||
| 180 | TESTSRV_3.DBNEXIA.COM | dbNexia_db | SIMPLE | - | - | - | FULL missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_3.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is SIMPLE. Risk score 180/100. Recommended fix
Run the full-backup job for dbNexia_db. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for dbNexia_db newer than 7 day(s). |
|||||||||
| 180 | TESTSRV_4.DBNEXIA.COM | dbNexia_db | SIMPLE | - | - | - | FULL missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_4.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is SIMPLE. Risk score 180/100. Recommended fix
Run the full-backup job for dbNexia_db. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for dbNexia_db newer than 7 day(s). |
|||||||||
| 180 | TESTSRV_5.DBNEXIA.COM | dbNexia_db | SIMPLE | - | - | - | FULL missing | Review backup policy and document restore-readiness status. | DBA |
|
Meaning
database 'dbNexia_db' on TESTSRV_5.DBNEXIA.COM has no visible full-backup baseline in msdb. Impact
Restore readiness is critical because all differential and log restore chains depend on a valid full backup. Recovery model is SIMPLE. Risk score 180/100. Recommended fix
Run the full-backup job for dbNexia_db. If the job already ran, fix msdb visibility or the backup tool integration so the full backup is recorded. Check target path, SQL Server service-account access and free space before rerun. Verify
Backup History should show a successful full backup for dbNexia_db newer than 7 day(s). |
|||||||||
Action plan12 prioritized
TESTSRV_1.DBNEXIA.COM / DOM_BlossomWhisper_FDD3
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_1.DBNEXIA.COM / DOM_DreamBlossom_D66E
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_1.DBNEXIA.COM / DOM_ForestDream_BD6D
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_1.DBNEXIA.COM / DOM_ShadowWhisper_67B1
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
TESTSRV_1.DBNEXIA.COM / DOM_ThunderMoon_622B
Run full backup, verify job schedule and confirm the new backup row in msdb.
DBA, today
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