To create an automated Database Backup at 7:00 pm

[Holli]

Hi,

I have a database that is split. I would like to create an automated backup of the BE to commence at 7:00pm each evening. Can anyone suggest the best approach?



Thanks for your help

Holli

[JoeM]

One way is to write a batch (.BAT) file or script (.VBS) that copies the back-end to wherever you like, and then schedule it to be run at 7:00 PM from Windows Scheduler from a computer that is always on at 7:00 PM (like a server).

Those scripts are pretty basic commands and can found on the internet with a Google search, once you have determined the details (which program you want to use, how you are copying to name, whether or not you want to compress it, etc). Here is one link that may be useful: https://www.youtube.com/watch?v=8s1KL7H2dUw

[Holli]

Thanks JoeM

I don't think I can do that my company has very tight security. Is there something I can create?

Thanks

Holli

[ItsMe]

Can you create a Task using Task Scheduler on your computer? Can you open the DB and create a record in a table?

[June7]

Doesn't your company already have process for nightly backup of the server?

[McArthurGDM]

Good point. I'll remember that for myself.