BACKUP SQL SERVER 2005

bkpSql2005.bat

BACKUP DATABASE [Guardian110] 
TO  DISK = N'C:\Backup\Guardian110.bak'
 WITH NOFORMAT, NOINIT,  NAME = N'Guardian110-Full Database Backup', 
SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO


FOR /F "tokens=1-4 DELIMS=/ " %%F IN ('date /T') DO (set v_date=%%F%%G%%H)
FOR /F "tokens=1-4 DELIMS=: " %%F IN ('time /T') DO (set v_time=%%F%%G%%H)
set homedir=C:\Backup\
set fname=%v_date%_%v_time%.bak
echo %vdate% %v_time% - %fname%

cd %homedir%

sqlcmd -S PORTARIAUN4\GUARDIAN4 -U sa -P toledodobrasil -i "C:\Backup\bkpGuardian.sql"

rename Guardian110.bak guardian_%fname%