Backup restore drill checklist when production looks healthy

Our dashboards said backups were green for months, but the first real restore drill failed on a staging server. The dump was present and the storage job had a success status. The failure came later: the target database was missing an extension, one role did not exist, and a scheduled job started writing before the app smoke test finished. I changed the drill into a repeatable runbook. First I…