Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

What Could Go Wrong?

By Steve Jones,

Be Prepared

It's the law of unintended consequences: things happening that you don't expect from a seemingly unrelated area. This article talks about a data center having leaks from carpet cleaning above. The concrete floor had aged and the carpet cleaners dumped water on the carpet to soak it through and it leaked. I'm not sure how people have data centers below office floors, but I know I've had a number of them at different companies where I've worked.

It goes to show you just how wide and varied the issues that your disaster recovery plans might need to deal with. All types of strange things can happen to your servers and it helps to have an idea of what to do when there is some type of issue. Can you imagine if there weren't sheets of plastic nearby? (see the article)

Not every disaster results in your setting up shop at another location and while many are serious, they can be resolved relatively quickly with good administrators that can think outside the box.

The situation is a good example of why you need to have good communication and information available to people working in the production areas. They should be able to contact someone that can give them access or at least accompany them to closed off areas, like offices, electrical closets, etc. They should also be able to contact someone with the authority to authorize expenditures and changes in policy because of some disaster event.

These types of things will always happen, but they shouldn't compromise your security or the integrity of your systems. Make sure that your disaster plans have accounted for different types of problems. Not specifics like fire, flood, but categories, like an event in that's limited in scope, that affects a whole floor or building, that occurs off hours, that could affect your block or even city, etc.

The one thing that probably applies here that I learned a long time ago is the Boy Scout Motto: Be Prepared.

PS - For those of you in the US, a moment of silence for those lost on 9/11.

Total article views: 126 | Views in the last 30 days: 1
 
Related Articles
ARTICLE

13 Disasters

This editorial that was originally published on Aug 15, 2007. It is being rerun as Steve is travelin...

ARTICLE

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

This challnge invites you to generate a Sierpinsky carpet using TSQL

ARTICLE

Versions of Disaster

Dealing with a disaster is a trying experience for anyone, but having to then worry about having the...

BLOG

Standing Desk – Flooring

My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowl...

ARTICLE

Disaster Recovery - An Afterthought?

Disaster Recovery is always ranked by DBAs and managers as one of the most important things to have ...

Tags
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones