Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

A quick code for backup using CABARC

Status
Not open for further replies.
Ramani,

thanks for that code. But I have always wondered:

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?

Thanks
 
Hi

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.

:)

ramani :)
(Subramanian.G)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top