Jul 012010

A key function of a DBA is to plan, test, and implement disaster recovery policies for the databases they maintain.  DBAs lacking these skills may also find themselves lacking a job if they are unable to recover data when necessary.  For all these skills we apply in the workplace, I have still heard via Twitter a few tales of woe regarding lost data in the home.

Having a disaster recovery strategy for your personal data is every bit as important as having one at work – maybe even more so because your precious memories are at stake.  I don’t have any fancy statistics to show how many people lose important personal data every year (67.2% of all statistics are made up on the spot anyway) but I’ll venture to guess that if you’re reading this blog, you probably have a digital camera and hence have photos and perhaps videos and music on your computer as well.  What happens to all of that when your hard drive fails?

My Backups: A History

From an early age I’ve been concerned with making sure my data was safe.  Long before digital cameras were the norm I still had data I couldn’t bear to lose, like all that 9th grade biology homework (just in case Mr. Monti needs to see it again) or every e-mail I’ve sent or received ever since I’ve had internet access.  As the type and volume of data has changed so have my methods and their effectiveness, but I’ve always had the same goal in mind.

I started to get interested in backing up my data around the same time that we got a computer with a Zip drive.  The thought that I could keep all of my important data on a single 100MB disk was mind-blowing back then and still is now, though for different reasons.  A few years later we got a CD burner and I was making weekly images of my system with Norton Ghost.  My freshman year of college I could fit my entire PC on 7 CD-RWs.  I got my first digital camera that year, and the volume of data I cared about started to grow at a faster rate.  External hard drives were getting cheaper, so I got one shortly thereafter and started taking backups of my system with PowerQuest DriveImage.

Problem: It’s All FlawedOld-School Backup

Everything I’ve mentioned so far during my brief history of consumer data storage technology is an ok method of backing up a home computer system, however some key flaws are present.  First off, the data is probably stored locally, meaning you have no real protection from a disaster.  Should your house burn down or be damaged by a hurrinadoquake, your backups will most likely be destroyed along with your computer.  If your house gets burglarized, they’ll probably take that external hard drive sitting on your desk.  While it’s very helpful to have a backup copy quickly accessible should you accidentally delete a file or if your hard drive bites the dust, storing backups locally might not help you much when true disaster strikes.

Second, none of these methods are really able to keep much history available.  CD-RWs weren’t expensive back then, but they weren’t that cheap either.  I had enough discs available to keep 2 backups of my system on hand, and later my external hard drive could hold 3 system backups at a time.  Since I took backups weekly, I had either 2 or 3 weeks to notice that something was amiss.  If I deleted a file and realized that I needed it a month later, it would be unrecoverable with either method.

Solution: The Cloud!

Cloud storage has gotten increasingly cheap over the past few years and has become an excellent medium for storing backups of personal data.  They represent the best of both worlds in that your data is stored in a remote location (or multiple locations) yet can be retrieved relatively quickly when you need it.  Since the capacity of the cloud is more or less infinite, many cloud backup services will save your backups for an extremely long period of time (if not forever), meaning you probably can recover that file you deleted a year ago.

Cloud backups are also pretty quick once you get started, as most software is intelligent enough to detect which files (or parts of files) have changed since the last backup.  A typical nightly backup of my system takes 5 to 20 minutes, but I have it scheduled so I needn’t think about it anyway.  I also no longer backup my entire system, just the partitions that have user data I care about.  Windows and other installations are easily replaceable – I’m just worrying about what’s not.

Backups to the cloud are great for a lot of things, but they’re no silver bullet.  One example I’ve encountered is with video.  I do a lot of video editing, and while I want a backup of each DVD I crank out, uploading all that data takes a prohibitive amount of time.  In the case of a disaster, spending hours or days downloading 4.7GB .iso files would not be optimal.  For this, I’ve found that a good ol’ safe deposit box is an excellent alternative.  I actually have boxes at two different banks located about 20 miles apart from each other (for full redundancy!)

Alright, I’d like to try backing up to the cloud.  What should I use?

There are several cloud backup solutions available at the moment, and I currently use two of them: Mozy and JungleDisk.  Over the next few weeks I”ll be posting reviews of my experiences with both of these services.  I’ll also cover Google Picasa Web Albums, as it’s an excellent way to backup your photos to the cloud for safekeeping.

  5 Responses to “Disaster Recovery Strategies for the Home”

  1. Great article. I think that I am over protective of the families personal files (photos etc.) My wife’s laptop drive failed several years ago and she (I) lost several months (100) of photos that were not backed up. She reminds me of this often (Since I am the IT guy at home). My own solution to this is to backup her personal files to ext disk every week and once a month I rotate the ext drive to the safe deposit box at the bank (includes my files and the kids files as well). Have several 500GB HP.

    As for the cloud. I just started using DropBox (Free 2GB) which is an awesome cloud solution that actually places a folder on your computer that looks like regular local storage. As you copy to the folder it sync’s up with the cloud. It installs a small footprint on your computer and you can even access from the web site.

    The downside with Cloud is are you ever sure that the other end is doing their part in backing up the data and what happens if their is a failure on their end. I like to at least keep my own copies of data for hard backup.

    Enjoyed your article.


    • Very true about not being sure what’s on the other end, hence why I’m using 2 services at the moment (but on different computers). Glad to know DropBox is working out for you. Thanks for reading!

  2. I’m a big fan of Carbonite and have used it for a couple of years. It’s not free but at $55 a year it’s very affordable and you can store unlimited data.

    It’s saved me from losing everything a couple of times and I used it to recover everything recently when I decided to perform a machine rebuild. It even keeps older file versions around for a couple of weeks so you can get at those as well (for those times when you overwrite something important).

    • I’m aware of Carbonite though admittedly I’ve never used it myself. As Cameron mentioned, you never know what’s on the other side of the cloud, and I know that came back to bite some Carbonite users last year, as they ended up losing data.

      Brent Ozar had an excellent blog post about this last year and actually got a reply from Carbonite’s CEO.

      I’m assuming/hoping that they have since figured this out so that it can’t happen again.

      • I was concerned back when that happened, I didn’t want to lose my stuff, however as I also keep a local backup I felt that it was an acceptable level of risk.

        One other thing I’ve found very useful (for scripts etc) is Microsoft’s Mesh product (mesh.com). While still in beta I have been using it for over a year to sync files between machines and also provide an online desktop where I can access my documents.

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">