The script backs up the database to a public folder, then moves it to the location I want. This is because I couldn't get it to backup directly to the location I wanted.
Code: Select all
echo off
cls
echo -- BACKUP DATABASE --
set DATABASENAME=ArgusTV
:: filename format Name-Date (eg ArgusTV-20130805.bak)
set DATESTAMP=%DATE:~-4%%DATE:~7,2%%DATE:~4,2%
:: Change backup path here
set BACKUPFILENAME=C:\Users\Public\Documents\%DATABASENAME%-%DATESTAMP%.bak
set SERVERNAME=.\sqlexpress
echo.
sqlcmd -E -S %SERVERNAME% -d master -Q "BACKUP DATABASE [%DATABASENAME%] TO DISK = N'%BACKUPFILENAME%' WITH INIT , NOUNLOAD , NAME = N'%DATABASENAME% backup', NOSKIP , STATS = 10, NOFORMAT"
echo.
echo -- moving file --
move /Y C:\Users\Public\Documents\%DATABASENAME%-%DATESTAMP%.bak "X:\ServerFolders\SQL Backup\"