If a disaster struck tomorrow, are you ready for it? Are you sure you thought of everything? I cannot count the number of times something happened, and I thought that I should have been able to anticipate that. It can be a big benefit to get another viewpoint on your disaster plan. No matter how well you think you’ve covered yourself, someone who thinks about things differently than you do can often see something you don’t.
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).
Reposted with permissions from SQLSoldier.net.