for /f "tokens=1-4 delims=/ " %%a in ('date/t') do (
set dow=%%a
set month=%%b
set day=%%c
set year=%%d
)
c:
if exist C:\SQL_Backup\Previous\*.bak del C:\SQL_Backup\Previous\*.bak
sleep 5
if exist C:\SQL_Backup\*.bak move C:\SQL_Backup\*.bak C:\SQL_Backup\Previous\
cd "C:\Program Files (x86)\Microsoft SQL Server\90\Tools\Binn"
for /F "tokens=1" %%a in (c:\batch\sql\db_list.txt) do call :Sub %%a
goto :EOF
:Sub
echo %1
SQLCMD -Usa -P"" -Q "BACKUP DATABASE %1 TO DISK = 'c:\SQL_Backup\%month%-%day%-%year%-%1.bak'"
:EOF
cd \batch