Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


Testing Your Data Protection


So far, this chapter has described the facilities that are available for the system manager to maintain the system. But how do you know that you are using the functionality in the right way, and that you will be able to get the system running again if something happens?

The answer is practice. When you have decided on a certain strategy, a disk crash should be simulated and the databanks restored following the chosen strategy.

Check that the contents of all tables are the same as before the simulated crash. Do not forget to simulate a crash of the system databanks (SYSDB, TRANSDB, LOGDB, SQLDB) and then restore or recreate them.

When you have decided on a successful strategy, then build command files (scripts) that take "normal" backups, backups on the fly, and create shadows.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX