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

Planning for Failure

By Steve Jones, this is better expressed with the Boy Scout motto: be prepared.

Things will go wrong. Mr. Murphy is out there, no battle plan survives contact with the enemy, and we all make mistakes. Hardware fails, disasters occur, and someone will knock their coffee cup over on a piece of electronic equipment. It's been happening for as long as I've worked with computers, and I'm sure it will continue to happen as long as humans build things.

When I give my basic SQL Server presentation, I talk about little disasters: the spilled coffee, the lightening strike that only affects your server, the DELETE query without a WHERE clause. These are the things that you prepare for, or you expect to happen and then build a plan to deal with when they occur.

In my career, I haven't had a lot of failures, but I have had a few. As I've gotten older, I've learned to be prepared, have backups (tested), and calmly followed through on my plans. I avoid trying shortcuts, but work through the issues as best I can, using my experience and well tested plans to get through the crisis.

No crisis will play out exactly as you have planned for it, but you should be following fairly well known procedures to recover in ways that you've practiced. Or you should call someone in that has more experience and can help you.

If I have a doubt, I move slower, not faster. I become more conservative, and if I am unsure about the outcome of an action, I've learned that time spent making another backup at that time is time well spent.

Steve Jones

The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at Comments are definitely appreciated and wanted, and you can get feeds from there. Overall RSS Feed: or now on iTunes!

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at

You can also follow Steve Jones on Twitter:

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

Be Prepared

Today we have a guest editorial from Grant Fritchey. The Boy Scouts motto is "be prepared" and most ...



A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...


Podcast Announcements

Podcast Feeds


Podcast Upgrades

A minor change for the podcasts next week. I got my wireless microphone, and I'm working with it a b...



I'm working on getting a small studio set up for some podcasting of the editorials. That means I put...


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

Already a member? Jump in:

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