>Hi All,
>
> I want to create a backup program using timer event. The program is to take the full volumn backup to the other volumn after every Hour. How can i do that. Can i use RUN xcopy '\\server\volumn'
>command? or is there any other way to take backup of the files/volumns thru vfp and also the faster and safer.
>
> And also if i use xcopy command, will it slow downs the server. and second main will it lock the files or not. means when doing xcopy other users will get disturb or not.
I would find this very disruptive for users. Any file that is open at the time will not get backed up, and, depending on the backup utility, could abort the remainder of the backup once an open file is encountered. I would explain this to your customers and let them decide if this is really necessary. We do all our unattended and automated backups at night.
We also use 3rd party software that loads at bootup where we can schedule backup times, volumes to backup, etc.
Otherwise, you could write a VFP procedure to open all the tables and do a
COPY TO \\server\volume\apps\myapp\backup\table_name [with CDX] for all your data tables. This assumes the tables are not being used exclusively. This also allows you to open the tables shared and not disrupt normal business use of the data. This simple copying would not lock any records or tables.
Mark McCasland
Midlothian, TX USA