Disaster recovery managementDisaster recovery plan maintenance <<previous|next>> :Backup and recovery enhancements in SQL Server 2005
Restoring data: Increase your efficiency
By Pierre Dorion
Ironically, we spend years learning how to master backups and then one day we are faced with having restore an entire environment in 24 hours! Shouldn't we learn to master the restore process instead? The problem is that we don't restore often enough, and when we do, it is typically a partial restore.
As we design our backup strategy, we need to start planning for restores. Here are a few items that should be addressed in order to increase the efficiency of the restore process:
Complete restore test: The ability to successfully restore critical applications from backups should be tested regularly. Avoid shortcuts; every step of the process should be executed and reviewed for possible issues. Restored data must also be validated to ensure everything is as it should be.
Documentation: As the above restore test is performed, each step should be documented. This will ensure that a single employee does not possess all the knowledge. The documented procedures can then become part of a master plan.
Restore dependencies: Some components of an environment need to be recovered before others can be restored. It is surprising to see how often authentication and networking is overlooked. This must be understood and documented.
Restore priorities: It is essential that the restore priority of applications be clearly established ahead of time by the various business functional areas. The IT team can only restore so many applications at once and unless properly informed, IT will set priority based on their understanding of criticality.
Know what to restore: If your recovery strategy includes a number of standby systems with a loaded operating system and applications, is it necessary to restore any of those files? This requires some backup planning to avoid having to sort out what to restore after the fact.
Backup data retention: How backups are expired must be closely monitored and managed. For example, the relationship between full database backups and associated logs must be clearly understood. Don't assume that automated deletion always works flawlessly and give it a regular check.
Have a plan: Last but not at all least is to have a plan. The critical applications recovery procedures must include the data restore and validation procedures. These procedures are then included as annexes to the disaster recovery plan and ultimately, become part of the overall business continuity plan.
Do you know…
About the author: Pierre Dorion is a certified business continuity professional for Mainland Information Systems Inc.
09 May 2006
Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.