>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only