@echo off
set dd=%DATE:~0,2%
set mm=%DATE:~3,2%
set yyyy=%DATE:~6,4%
set curdate=%dd%-%mm%-%yyyy%
set username=USERNAME
set password=PASSWORD
set db=BD_NAME
sqlcmd -S SERVER -U %username% -P %password% -Q «BACKUP DATABASE [%db%] TO DISK = N’D:\SQLBackup\%db%_%curdate%.bak’ WITH NOFORMAT, NOINIT, NAME = N’%db%-full’, SKIP, NOREWIND, NOUNLOAD, COMPRESSION, STATS = 10»
:: Копируем во временный каталог
xcopy «D:\SQLBackup\%db%%curdate%.bak» «\\BKP_SERVER\SQL\» /e /y /c /q && del «D:\SQLBackup\%db%%curdate%.bak» /Q