The primary strategy of an effective computer database disaster recovery plan for floods and other disasters is backup planning. There are three basic types of backup plans:
- Incremental – piecemeal backup that may save the most current, important data, going backwards in time, or may backup one PC at a time
- Differential – saves all of a computer’s NEW data and NEW database info since the last time a full backup was performed
- Full – saves all data from all computers and databases
A reliable and efficient computer database disaster recovery plan for floods and other emergency situations will likely use all three methods. When and how often each mode is used will depend on a schedule that your planner should draw up based on the risk to your hardware and computing system.
How Is Your Data At Risk? Catastrophes on the level of Katrina are probably not common occurrences in your location but a good computer database disaster recovery plan for floods and other disasters will take into consideration every event — from when natural disasters like a flood or drought is likely to occur to the history of power outages in the area.
Such events as flooding or an earthquake can severely threaten hardware, but hardware is replaceable. The information stored in it, however, is not so easily replaced.
So if you are in an area prone to such disasters, your plan should provide for offsite data storage. Where power outages due to electrical storms are common enough, you should not only consider databases (offsite or on) to preserve the integrity of data but access to all of it as well.
How Much to Spend? After risk, the next thing to consider is budget. And the best thing you can spend on is a backup system. Any IT planner will tell you it is always better to spend on backup than recovery.
To know how much to spend, ask yourself how long you can afford to do without computers and data if one of the risks you are planning for should occur.
If yours is a small company, you can probably do with regular backup measures, such as keeping backup files offsite in a disc, hard drive, or laptop.
If your business is a little bigger, you will probably need to spend from two to eight percent of your IT budget. For a bigger business that relies heavily on IT a good figure would be 15% of the IT budget.
The good news is that these percentages can be more flexible as a computer database disaster recovery plan for floods (and other emergencies) is now available as out-of-a-box software.
Some examples of these are Zmanda Recovery Manager for MySQL, Recovery for SQL Server, and Oracle Recovery. Search for them at popular vendor sites where downloads of the programs can be tested and purchased.