Script to backup database, need to make new copy instead of overwrite old copy
Posted on 2012-04-10
I have a script that can be ran to copy a access database to another backup folder. It works well and adds the date to the end of the file but I wanted to see if there was a easy way to edit the script so that I can copy the same DB into the folder more than one time a day. The way it is now if I run it again it will replace the original copy but I want to have two copies with the same date. The problem is we need to make sure the file is backed up before any major changes are made and we need multiple copies in case we have to get data from a old database.
So I need to end up with something like this if I run it multiple times the same day.
Something like that.
Copy %Source% %Destination% /Y