create a folder with dates,

[sharkster]

hello,

what i need is help with making a batch file that automaticly back up my work i know how to do this and how to make the folder the backed up work will go in to, BUT the bit i am having trouble with is i need a script that will rename or make a folder with the current date.

any will will be appreciated.

thank you

[el8linuxel8]

cd E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\

 

SET _day=%date:~0,2%

 

SET _month=%date:~3,2%

 

SET _year=%date:~6,6%

 

SET date=%_day%%_month%%_year%

 

copy wbls m:\eclipsebackups\wbls-%date%

 

i wrote that to get around the fact that date /t contains /'s which are invalid in folder names (yeah, way to go M$)

 

hope that works for you

[Heebeejeebee]

My manual backup of SIMS goes something like this:

 

REM *** Backs up the SIMS Databases ***

 

DBATTACH /DATABASE=sims /backup /auto /user=******** /password=************** /SERVER=sims\sims_db

 

REM *** Copies the Docstorage Folder ***

REM *** Setdate creates a folder structure with the current date as the folder name

 

setdate.exe yyyymmdd

call setinto.bat date

 

xcopy d:\sims\sims\docstorage\*.* "D:\Sims\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\Docstorage\%date%\" /e /y

 

xcopy d:\sims\sims\fmssql\db\sims.db "D:\Sims\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FMS\DB\%date%\" /y

 

xcopy d:\sims\sims\fmssql\db\sims.log "D:\Sims\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FMS\DB\%date%\" /y

 

xcopy d:\sims\sims\fmssql\db2\sims.db "D:\Sims\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FMS\DB2\%date%\" /y

 

xcopy d:\sims\sims\fmssql\db2\sims.log "D:\Sims\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\FMS\DB2\%date%\" /y

 

del setinto.bat

 

... and uses setdate .exe to set the variables.

 

Can't remember where I got setdate from now so I can't credit it.

 

Hope this helps

 

HBJB

setdate.zip