Get rid of tape? I don't think so. But that's what Synopsys is considering with the installation of new storage appliances and software from Data Domain, EMC, and Network Appliance.
Disclosure: I have friends that work for Network Appliance, so I may take gratuitious shots at them for the sake of humor
While you might look forward to having Jennifer come install a Network Appliance SAN at your site, it might not be worth giving up your tape system. After all, if there's a fire near your building and the fire department comes, you might experience delays as she and the rest of the females nearby stop working stand in awe of those strong fireman. How do you back up your data when a 2TB appliance is sitting half installed and you've already arranged for the removal of your tape system to the local eBay retailer!?!?!?!
And even if you get the appliance installed with Data Domain's de-dupeing software and get a 20:1 compression, how do you get those bits back when you need a restore. Bringing back every 20th bit on a SQL Server database just isn't practical. :)
All fun aside, archiving data requires lots of space. And coming up with a scheme to avoid every day fo the last 7 years is possible, but not easy to manage necessarily. You might get by with every day of the last week, end of months, and then end of years, but who knows. Plus there's always the chance of an audit for some snapshot on the day before or after a close of month or quarter.
I do think that using disk storage can help reduce your tape needs, but over time, especially with more legal requirements to keep data records for long periods of time, a tape system is still probably an essential tool for most companies.
Steve Jones
Two words here: OFF SITE.
That wonderful SAN in your data center can burn to a crisp just like the rest of the building. I have had too many clients involved in disasters to not have learned the lesson. None were involved in 9-11 but that was a wakeup call too.
Three more words: TEST YOUR BACKUP.
Backups are no damn good if you can't restore them. I recovered data from a client with a faulty tape system. All the bytes were there, just not in the right files. Days on end were spent trying to piece that back together. I even ran across a tape system that, when verifying the backup only ensured that the tape was readable. I asked the vendor if there was a way to compare the data on the tape to the data on the drive. The respose was, "Why would you want to do that?" We did not buy that system. Guess why.
'Nuff preaching.
Among the other duties of life in the electronic fast lane, I'm the monkey that feeds the tapes into the machines.
I have also experienced reading log after log of successful backups with a redundant verification of what's on the tape only to find it lied when it came time to recover. I long ago set up backups to first be copied to another drive and then to tape for both redundancy and speed of restores.
But, I am also now looking at a backup scheme using USB drives (becoming more inexpensive every day) for each server and actually swapping those out on some sort of schedule instead of tapes. Coupled with offsite backups either across the network or Internet, tapes just might be on the verge of being replaced.
And the monkey can find something else to do like read SQL forums...
We got rid of tape several months ago, utilizing removable 250gb hard-drives in a 4 drive external SATA II tower and a separate NAS.
We use imaging software to get a fresh image of each server on the weekend, then incrementals throughout the week at one hour intervals. The images are created on a 1.5TB NAS device which can hold mutliple weeks of data. A copy of the base (full) images are copied to one of the removable drives, its popped out and sent offsite (weekly). The hourly incrementals are created on the NAS with a copy moved to another one of the removable drives and transmitted electronically offsite on a daily basis.
In case of a disaster, if we can grab the current drive on the way out the door, we stand to lose no more than the current hours worth of data. If not, then we may be out 2hrs depending if the offsite synch has completed. For normal backup functionality we have hourly snapshots of our data for file restoration which takes only a few minutes (<5) with the hard drives vs considerably longer with the average tape restore.
Granted our storage needs are modest by most standards, but with the size of SATA drives now over 750GB, its a good solution for many.
