Here’s a checklist of things you might not have considered. This can be your other set of eyes.
DR Plan Sanity Check
|Recovery from Data Loss
Table dropped, data deletion, update gone awry, etc
|Recovery from Server/Storage Failure
SAN/NAS/DAS failure, server failure, VM host failure, local storage failure, etc
|Recovery from Corruption
Single page restore, partial restore, index recreation
|Recovery from Localized Disaster
Hurricane, earthquake, explosion, power outage, flood, etc
|Recovery from Widespread Disaster
Massive asteroid, super volcano, zombie apocalypse, alien attack, other cataclysms
Download printable version: https://sqlbp.com/wp-content/uploads/2017/09/DRPlanSanityCheck.docx (61 KB).