Home > Blogs > The "D" in HADR

The "D" in HADR

By  Jul 6, 2010

Topics: SQL Server, Data

HADR is an acronym that stands for High Availability / Disaster Recovery. Although you can think of these two concepts individually, I prefer to think of them on a continuum. If your system is spread out across multiple locations, for instance, it can be both highly available and able to quickly recover from a disaster.

The “D” stands for disaster, and it’s important that you’re ready for those. Most of us have a good backup plan in place, and we’ve practiced a restore operation to ensure all that works. But one thing I don’t see a lot is a set of documentation that shows what to do in a disaster – a DR Plan. I’ve written about these before, but the basic idea is some electronic or even better, paper instructions that explain what to do to recover the systems. This includes things like the location of the backups, the systems needed to restore the backups, the impact analysis and so on.

Do you have one of these? Does everyone on the team know where it is? How about the non-technical folks, in case you’re not available and they need to call some technical help in? Would they know where to find it?

In a disaster, people aren’t always thinking clearly. So make sure your documentation is discoverable, and that it’s easy to follow – at least for a technical professional.

Become an InformIT Member

Take advantage of special member promotions, everyday discounts, quick access to saved content, and more! Join Today.