Measures to reduce security threats Data
and File protection
Backup & archiving strategies
|
Backup:
A "snapshot" of the database, usually at a time of minimal activity.
This may be a problem in a globally distributed database.
This is often achieved using the operating system backup utilities.
A backup is really an insurance policy against data loss.
Archiving:
Saving data "off line". (eg. Historical data).
Records may be copied to "Archive" tables, that are stored "off-line"
but have the ability to be reloaded back into the system, or a separate subset of the
system.
This is important to keep the size of the database managable and maintain performance.

|
A simple backup strategy used for backing up data where data
changes occur daily is as follows;
- Four week plan requiring 8 data cartridges.
- The Master tapes contain your entire Hard disk, and should be stored off site.
- The day tapes contain only changes or additions.
- It is a good idea to clean your backup hardware regularly.
- The grand master should be a new one each month.
- The plan shown is used when data changes on a daily basis, determine your own
requirements for a suitable plan.
- Your data backup is only as reliable as the backup media. You should regularly test the
integrity of the backup.
[Ref 104]Verbatim (94) |
- Computer cabinets may be used to store duplicate copies of data on-site.
- Note that burglar resistant safes DO NOT provide suitable protection for magnetic media.
- Fire tests have proved that magnetic media stored in fire protection cabinets, designed
only to protect paper would be destroyed in minutes.
- Paper records begin to deteriorate at approximately 170°C, Microfilm at approximately
93°C, but computer software is damaged at temperatures approaching 65°C.
- A fire in close vicinity to the computer suite could result in total loss of
information.
[Ref 100]Chubb ( 89)
[Rev: 2/10/98] 24/9/98 © 1996-98 V/2-Com (Verhaart), P O Box 8415,
Havelock North, New Zealand.