backup MS SQL

backup_sql.bat

@echo off
set HOSTNAME=server\sqllab
set USERNAME=sa
SET SQLPASSWORD=password
SET FILENAME=BDLAB
SET BACKUPPATH=C:\SQLDATA\backup
SET BACKUPSQLSCRIPT=%BACKUPPATH%\dbbackup.sql
SET TIMESHTAMP=%DATE: =0%
:: Выполняем скрипт в SQL
sqlcmd -S %HOSTNAME% -U %USERNAME% -P %SQLPASSWORD% -i "%BACKUPSQLSCRIPT%"
:: Архивируем
"C:\Program Files\7-Zip\7z.exe" a "%BACKUPPATH%\%FILENAME%_backup-%TIMESHTAMP%.7z" "%BACKUPPATH%\*.bak"
:: Удаляем лишнее
del "%BACKUPPATH%\*.bak"

dbbackup.sql

DECLARE @pathName NVARCHAR(512) 
SET @pathName = 'C:\SQLDATA\backup\backup_' + Convert(varchar(8), GETDATE(), 112) + '.bak' 
BACKUP DATABASE [BDLAB] TO  DISK = @pathName WITH NOFORMAT, NOINIT,  NAME = N'db_backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10