>>>>>What would be the simplest way to ensure that all the tables are backed-up on a regular basis? Not really so much how you would do it - we would use DynaZip or something like that - but more where/when should it be done? If we wanted it to happen at least once a day, and there could be multiple workstations accessing the data on a server (of which we have no admin control). When to do it? On shutdown of the app? On startup? Do you do it at the very end of your Main.prg that is starting the app in the first place? What is the best way?
>>>>
>>>>
>>>>Maybe at a different application which should be run from Windows Scheduler when everybody is supposed to be out (3AM or something)
>>>
>>>That is a good idea.
>>
>>A very good idea. That's how we do it.
>
>How do you handle it if they are not out?
Don't know. There is an operations group that handles it. It is also not a VFP application. On an overly simplistic basis, If I were writing this sort of app in VFP it would be something like
lcError = ""
FOR all the files that need to be backed up
TRY
COPY FILE (source) TO (target)
CATCH
lcError = lcError + (source)
ENDTRY
ENDFOR
IF NOT EMPTY(lcError)
Send_Unable_To_Copy_Email
ENDIF