what is going to happen to my data when they are backupped (with WinZip, CabArc, Dynazip, whatever...) since I know that in every single moment my app keeps tenths of files opened?
I know that i.e. WinZip can handle opened files, but what is their state when the time comes to restore it after, for example, an HD crash? Isn't that a bad time to discover that they are useless/unstable?
Maybe I am excessively worried. Can someone shed some light on this?
The backups taken will not be perfect when other users are in.
The perfect way is to make users out, log in an single user with some sort of protection that other users dont login and take the backup.
In circumstances where this is not possible, you should think of mirroring your server. In such cases, there is possiblity to shut only the mirroring for a while and then take backup, then restart the mirroring.
There are utilities to backup while the process is on, but VFP related tables may show errors when backup done so is restored.
Another way is to have a backup form with a timer and schedule the backing up using the VFP code at midnight when no user is likely to be asking for service. We can force users out, just in case, someone left the machine on while inside the application. There are realted FAQs on this as to how we can force users out.
Since in reality, the backing up takes very less time, towards the end of the day or beginning of the day, i advice my users to take backup positively. The code takes care of keeping users forced out during backup.
Where there are sizable volume, I just provide for disk copy in another harddisk (takes few minutes) and then archive that. I am talking about only VFP data.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.