sqlbackup.bat

@echo off

set dbname=test
set dbuser=sa
set dbpass=yourpass
set dbserver=Seele\SqlExpress

set dest=\\192.168.1.1\disk_a1\

set PATH=C:\Program Files\Microsoft SQL Server\110\Tools\Binn
set TEMP=D:\Temp

for /f "tokens=1-4 delims=. " %%a in ('date /t') do (set mydate=%%a-%%b-%%c)
for /f "tokens=1-2 delims=:" %%a in ('time /t') do (set mytime=%%a%%b)

set dbbak=%TEMP%\%mydate%_%mytime%.bak

osql -U %dbuser% -P %dbpass% -S %dbserver% -Q "BACKUP DATABASE %dbname% TO DISK='%dbbak%'"

move %dbbak% %dest%