>>What is the best way to backup clients importaint data (tables and databases). Especially when my users have troubles with power supply. They often have Power failures. And I nticed that persistent relationships are very sensitive on this (allmost allways I loose primary keys). Have anybody troubles like me?
>
>In your case I would make extensive use of FLUSH to be sure the data is physically written into the tables asap.
>
>José

Two things here.. If this is a network envirmonet, get a UPS or stable power supply for the server.. Secondly, is the app ever down?? I mean in the case, are there times when there are no users in the system?? If so, then I would have a person there making a tape backup, nitely or how ever often they can afford to do backups..

I will also agree with Jose, on using the flush command, when ever you do a replace or update, follow it with a flush() to force the write out to the server..

Thanx!

Tony Miller
Vancouver, Wa