>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.
>
>TIA
>
>Amit
why not let VFP do the copy for you?
lncount=adir(latables,'your_path\*.dbf')
for i=1 to lncount
lctable=latable(i,1)
use (lctable)
copy to my_backup_path\+lctable with cdx
use
endfor
I do this and then do a dynazip to zip them.
This way I get all open tables, nobody is bothered by open tables.
__Stephen