-----------------------------------------------------------------
do_backup_databases.cmd

@echo off

set outputpath=d:\zhaix\backup
set rar=c:\Program Files\winrar\rar.exe
set sqlfile=__backup_database.sql

set namestamp=%date:~0,4%_%date:~5,2%%date:~8,2%

set backupfile=%outputpath%\ZhaixNoxForum_%namestamp%.backup
set rarfile=%outputpath%\ZhaixNoxForum_%namestamp%.rar

del "%backupfile%"

echo Ready to backup database to %outputfile%...
sqlcmd -i "%sqlfile%" -v backupfile="%backupfile%" -v database="ZhaixNoxForum"

del "%rarfile%"

"%rar%" a -ep "%rarfile%" "%backupfile%"

del "%backupfile%"

-----------------------------------------------------------------
__backup_database.sql

DECLARE @filename AS NVARCHAR(200)

SET @filename=N'$(backupfile)';

IF 1=1
BEGIN
BACKUP DATABASE [$(database)]
TO DISK = @filename
WITH NOFORMAT, NOINIT,
NAME = N'$(database)-Full Database Backup',
SKIP, NOREWIND, NOUNLOAD, STATS = 10
END;

GO

QUIT