Only a good backup can be used for data recovery.
A “good backup” is a backup which is suitable for restoring a system which has failed. If the backup can not achieve this goal, it is a “bad backup.” Fuzzy backups, which refer to data backed up from SQL systems which the composing sub-parts are not in sync, represents such a “bad backup.”
All too often, the need for a a suitable backup only presents itself after a disaster has negatively affect the primary business site. This is when the need for a backup is most pressing and it becomes clear it does not exist.
In order to prevent such a situation from occurring, it is recommended that backups made are
- regularly verified to confirm that it does contain the expected data;
- regularly tested in a simulated disaster recovery scenario;
Records should be kept of the
- type(s) of data to be stored (eg SQL databases, files & folders, etc);
- the application which use this data and the tools required to make the backups;
- the person(s) responsible for each backup;
- the Last Known Good Backup;