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

Crash and Burn

By Steve Jones,

Coding Horror, one of the blogs I follow, had a crash recently. I noticed it from Jeff Atwood's tweets, and when I checked, his site it was down. The story was picked up many places, including Data Center Knowledge and the image below is what I saw when I went to the site:

CodingHorror down

He also had posted a query on Superuser about recovering his data. It's back up now, but it was a hard lesson for him to learn, and a little embarrassing for someone that's running a programming site teaching people how to better build systems.

Jeff wrote up more details on the event and actions taking, including blaming himself for the issues. That's appropriate and it makes sense. It's also a funny read since he references some of his own advice that he had not taken. We are responsible for our own data, and I'll pause writing for a minute while I go make sure my data is backed up! Yep, I'm safe, everything backed up to another machine.

You never know when you are going to run into an issue, and with so many companies distributing the responsibilities for backups to separate groups, it's easy to assume someone else will take care of things for you. However as this story shows, you need to double check things. You need to ensure that backups are really being made. And there's one good way to do that.

Perform a restore.

I've written about it before, but I'll say it again. Backups don't really matter; restores do.  Unless you can actually restore the data, the backup, or the process of doing a backup, doesn't matter. The only way to be sure your database, your VMs, or even the picture of you from last summer's vacation is safe is to perform a restore.

I just did one, deleting an old editorial from my machine and then pulling it back from my Windows Home Server. You might try doing one today as well, especially for those critical files.

Steve Jones


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. Comments are definitely appreciated and wanted, and you can get feeds from there.

You can also follow Steve Jones on Twitter:

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 www.everydayjones.com.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

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

Backup/restore

Backup/restore

BLOG

Podcasting

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

FORUM

Restore multiple Differential backups

Restore multiple Differential backups

FORUM

Unable to restore backup

Unable to restore backup

FORUM

Backup and restore

Backup and restore

Tags
backup / restore    
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