Preparing for Design › Prepare a Contingency Plan

Prepare a Contingency Plan

Integrity controls can never be completely effective. Even if it were possible to identify every potential risk, the cost of securing against all of them would probably be prohibitive. For this reason, you must establish a contingency plan.

A contingency plan is a set of provisions for events that interrupt or destroy information processing capability.

Contingency handling should be designed into the system. It is too late to start contingency planning when things begin to go wrong.

A contingency plan should contain the following procedures:

• Fallback-Lets business activities continue while the normal computer system is unavailable.
• Back-up-Devised to take regular copies of data and transactions to be used in case of loss or corruption of the database.
• Recovery-Can be performed to enable a return to using routine computing procedures after a failure. This can involve:
  • Roll back, the reversal of changes made by the current transaction.
  • Restore, the resetting of stored data to the state immediately following the most recent back-up.
  • Roll forward, the rerun of the current transaction after a roll back.