Fri 20 Mar 2009
The past week has given me major troubles. I was tasked with performing a restore of a large database from our offsite storage. Upon getting the tapes back I found that their indexes were no longer available and I would need to read them in from the tapes…there were only 107 tapes. Not knowing the software well enough to accomplish this quickly I contacted support, where things began to get more…”interesting”.
After four hours on the phone I was able to determine the two tapes that would be needed to recover the 79Gb database file and started reading in the specific saveset that was needed. Two hours later I was able to start a restore, which failed. 2Gb of the restore file was missing. After another two hours on the phone with support I was told “Let’s reposition the tape. It could take a while, on newer technology I’ve seen it take an hour, on LTO1 and LTO2 drives I’ve seen it take 8 hours.” You guessed it, I have LTO2 drives. Fortunately I have a multitude of drives to reposition the tapes with so it won’t impact backups, unfortunately I have a time limit on the restore that’s fast approaching.
So what do you do when you backup your file systems? Do you simply believe that the software you backup with validates your tapes or do you test them regularly? Are you satisfied with seeing an email at the end of a backup routine stating “SUCCESS”? Then answer is simply NO. Your backups are only as good as your ability to restore from them. Keeping that in mind and all the different technologies and services available what do you choose?
For us the answer is simple. We require low cost, reliable, offsite secure data storage as do most companies nowadays. TAPE. We’ve looked into collocated services and replicated SANs with virtual tape backup but the cost far exceeds it’s benefits. Tape technology has been proven over and over for decades. There is no cost effective replacement for a good old fashioned tape, even taking into consideration the troubles it can give you. Our entire datacenter can be put onto 6 tapes costing $25 each. 4.8TB for $150.
Any good backup initiative should be followed up with an equally adequate restore plan. So next time you recommend a backup solution plan a regular restore plan to test because there’s nothing worse than spending an entire week restoring one file.