When did you last test your disaster recovery strategy?

This post is a departure from our normal Q&A style because I think this is a very important question you have to ask yourselves.

Related: The Smart DBA's Guide to SQL Server Disaster Recovery, Part I

During our first class of the year a couple of weeks ago, the most recent large earthquake struck New Zealand. One of the students (Martin) was from Christchurch and almost flew home that day, but after finding out that family and work were safe, decided to stay.

Just this morning an incredibly powerful earthquake hit Japan, with an even more destructive tsunami causing devastation.

Apart from the appalling loss of life in both cases, there’s also the economic impact to consider from companies being unable to conduct business.

Which brings me to my question for you: When did you last test your disaster recovery strategy? It’s all very well having a strategy, but how do you know it works?

Conduct Regular Testing

You have to conduct regular testing so you can tell whether the assumptions you made when the strategy was formulated still hold - such as the time it takes to perform a bare-metal restore fits within the Recovery Time Objective.

Later in the week in our class, Martin gave us a short lecture about how his business had reformulated their disaster recovery plan after the previous large earthquake hit New Zealand. He raised some interesting points like:

I wrote a longer blog post about disaster recovery testing a few years ago – see Importance of testing your disaster recovery plan.

Edit: And I’ve just kicked off a survey on my personal blog about testing DR plans and whether they anticipate human nature. I encourage you to respond (it’s anonymous) – we’ll be surprised by the results I think. See Surveys: DR plan testing and considering human nature.

Allow for Human Nature

Events like these should get us all thinking about whether our disaster recovery strategies are adequate, and whether they allow for human nature during a disaster.

Stay safe.