Maximum PC

I'm a noob to batch files so bear with me.
I am copying a sql backup to another server and my batch file looks something like this:
copy "D:\data\backup\sql\backup.bak" "\\server\backup\"
I have it setup to run as an automated task over night but I want the file to be renamed to include the date. Is there a switch that would enable me to do that?

*edit* now that I think of it couldn't I just have it generate a file like backup1 backup2 and so on? Then I could just clear out the old ones every week or so.

Just specify the date in the filename.

i.e.

copy "D:\data\backup\sql\backup.bak" "\\server\backup\backup_041108.bak"

I would have to go in each day and edit the file though wouldn't I? I want something that will do it automatically.

Here you go. You may want to change the naming convention & make at least 7 batch files (1 for each day of the week... Mon2300, Tues2300, Wens2300 and so on)
http://www.maximumpc.com/forums/viewtopic.php?t=68610

Why are you using \\server\backup\xxx
Map a network drive & use the drive letter "N:\backup\xxx"

Check out our F@H team too!


You could probably use ntbackup too. It should already be installed or you can download it from M$'s website.
Go to start, run & type ntbackup, press enter.

Couldn't you do some variable substitution for the destination?

like this (this isn't the correct syntax -- I usually code bash scripts)



That should help somewhat.

smartcat, that's what I am looking for now if someone could chime in with the syntax.
00john00, I've thought of that, but would like to avoid it if its possible.

I would love to avoid it too if possible but there's no other option thats so simple/fool proof.

Found how to get the date as a variable:



Use example:


From: http://support.microsoft.com/kb/555314

I prefer



enjoy!

*It should also be noted that you will need to use %%A, %%B, %%C instead of %A, etc. when inside a batch file or you will have syntax errors that will drive you crazy.*

That is just plain ugly...