Autiomated BackUp of Back end database

[AndyShuter]

We are currently running a FE / BE splitted database abd would like to back the back end up (to a sepearate location) every 15 minuutes by using the On Timer event.

Troiuble is, I believe I cant use the CopyDataBaseFile method whilst other users are in it and it would be too much hassle kicking everyone off!

Manually copying and pasting is good, but would really like to crack this one

Any suggestions please?

Regards

Andy

 

[ghudson]

Search around for there are [believe it or not] other postings related to your question. I have posted a function that allows you to copy and zip [using WinZip] a database file even if the database file is open and in use. Try out that fancy search button the forum so graciously offers for you convenience.

 

[AndyShuter]

Cant see the function mate

 

[ghudson]

Well I just searched for the keyword "backup" and I only found 500 threads.

Here is the one I mentioned... Back up and zip code from ghudson It has only had 4,123 viewings.

This is another good method for backing up and also updating the objects in your db... Export All Database Objects Into Text Files