Batchfile help date time stamp

[razaqad]

I'm using a batchfile for backup of the Backend.

i'm using the following command to copy the backend folder to the desired location:

xcopy "E:\MyDB" "f:\Backups\MyDB\" /f /r /E /H /K /Y /I /C /D

I want that each time the back end to be copied witth a different name e.g Timt-DATE-MyDB

how can i do this using a batch file.

 

[The_Doc_Man]

Well.... technically you can't. So here's how you do it anyway.

First, in your scheduler that runs the backups, run a macro out of your database (See /X command-line option of Access) just before you are about to back up your database. Have the macro run some code. Have the code create a .BAT file that looks like this little two-liner:

md f:\backups\mydb\db_timetag_bk\
xcopy "E:\MyDB" "f:\Backups\MyDB\db_timetag_bk\" /f /r /E /H /K /Y /I /C /D

Have the code delete the old copy of the .BAT file before it tries to create the new copy. Remember that the macro has to include a quit command when it is finished with the RunCode option.

Then just run that .BAT file from the command prompt with the AT command.

 

[razaqad]

here is what i have found http://www.access-programmers.co.uk/forums/showthread.php?p=490274#post490274

 

[ghudson]

Why not do it with VBA?

Back up and zip code from ghudson

You can skip the zipping part of the code if you do not want to use WinZip to compress the backup file.

 

[razaqad]

coz ... there are so many different front ends for the same db .... i can schedule it through windows task scheduler to run once a day or as desired ......