I remember the day, not many years ago, when data warehouse programs would annually undergo a disaster recovery plan test. This usually involved a weekend and usually involved some important revelations in terms of readiness! I've noticed in the past year that those tests are seldom done anymore. Not being a server expert, I assumed that there were some important new built-in capabilities to servers or more failover environments in place that removed the need for the exercise.
So, I began to make it a point to find out more and, while surely the servers have improved in this area and there are more failover arrangements in place, the primary reason data warehouse disaster recovery plans aren't done as much seems to be that the exercise is out-prioritized. This is not a great reason. Of course, averting a disaster is always a tough justification in light of the many clearly progressive things we like to do for our data warehouse environments.
But consider these simple things that form the basis of a sound disaster recovery plan, as given to me by a systems expert...
1. Have a backup strategy that you execute; usually this will mean daily backups of all production servers (my expert discouraged incremental backups) and hourly log backups
2. Diagram the network in detail with specifications and contact numbers (incidentally, CSI has capabilities here we call ClarityPath)
3. Prioritize systems and connections by acceptable downtime; this prioritizes the recovery effort focus
4. Build a recovery team including these roles - project leader, communication leader and technology experts who are on call 24 x 7
5. Test the plan (the premise of this blog entry) which includes testing those old tape drives to make sure they can read the old tapes still needed
6. Review the plan systemically once per month - make it a living document
7. Put up a secure website where status can be communicated in the event in-house systems are down and people are working from off-network computers
It's obviously difficult to evaluate these team members on the basis of something that will likely and hopefully never occur. Therefore, readiness metrics are more appropriate for the evaluation.
Posted November 15, 2005 1:21 PM
Permalink | 3 Comments |
Twitter 
LinkedIn 
YouTube
Data Recovery Wizard is a file undelete and data recovery utility for Windows 9x/ME/NT/2000/XP/2003. DataRecoveryWizard can recover files accidentally deleted, including files removed from the Recycle Bin, in a DOS window, from a network drive, from Windows Explorer with the SHIFT key held down, provided that recovery is attempted before the files are permanently overwritten by new data. DataRecoveryWizard supports NTFS encryption and compression, alternate data streams, sparse files, Unicode filenames, etc. Except in severe cases, both the file and the folder path leading to the file can be recovered.
download free at
http://www.yaodownload.com/utilites/file-disk-management/data-recovery-wizard/
StompSoft's Recover Lost Data is a full featured file recovery software that can quickly and easily recover data that has been accidentally deleted or lost. It allows you to recover data lost due to program crashes and viruses as well as gets back permanently deleted email messages from various programs. You can also recover pictures, music files and data from most digital cameras, MP3 players and other removable storage devices.
http://www.stompsoft.com/recoverlostdata.html
In the past I've had great success with FileSalvage from SubRosaSoft. I've tried other products and nothing does a better job on Mac OS X. From time to time I delete files by accident and FileSalvage has rescued me from having to recreate hours of work a number of times. I also used it to recover lost files off of my Canon camera. FileSalvage is the best data recovery program in my opinion.