Sample database backup

echo off

SET Today=%Date: =0%
SET Today=%Today:~-4%%Date:~-7,2%%Date:~-10,2%
SET Now=%Time: =0%
FOR /F "tokens=1,2 delims=:.," %%A IN ("%Now%") DO SET Now=%%A%%B

SET FileName=WebPortal_%Today%_%Now%.bak

sqlcmd -S Server -U UserName -P Password -Q "BACKUP DATABASE WebPortal_UAT TO DISK='D:\DbBackups\WebPortal_%Today%_%Now%.bak'"

ECHO The database has been backup to D:\DbBackups\WebPortal_%Today%_%Now%.bak