Automated Backup of Database or table

[696796]

Hello,

I have searched on this but didn't find much...

I am looking into methods of data recovery in case our systems go down at work.

Is it at all possble to backup the database to say the C:\ at a regular interval, ie. at 12pm every day. The backup would overwrite the old file.

Kind regards,

alex

 

[696796]

P.S - I don't want it on the click of a button, just like a scheduled event.

 

[jsteph]

Many ways to do this...if you have Task Scheduler, which I think came with w98 and up, you can, at the simplest, run a .bat file to copy the file. With more advanced batch script or windows scripting, you can name the file with a sequenced name so overwriting isn't needed, and you'd have a poor-man's incremental backup.

There's also Windows Backup, which, while it is a buggy, unstable tool, will likely work for these purposes, and you can do incremental with that as well.

Keep in mind disk space when doing this.
--Jim

 

[696796]

I like the sound of that, i'll do some research on batch files and let you know how i get on...

 

[696796]

I have created the needed bat file, i just thought it may be a good idea to run it on the click of a button on a form.

How do i call the bat file from VBA?

 

[696796]

Done it thanks,

Dim RetVal
RetVal = Shell("C:\Documents and Settings\marchale\Desktop\copytest.bat", vbHide)