Skip to content

Instantly share code, notes, and snippets.

@pedroinfo

pedroinfo/Backup.bat

Created November 22, 2016 19:15
Show Gist options
  • Save pedroinfo/f980bda98bac970bb10f53bf888ea4ca to your computer and use it in GitHub Desktop.
Save pedroinfo/f980bda98bac970bb10f53bf888ea4ca to your computer and use it in GitHub Desktop.
Download ZIP
Backup SQL Server Express (Script BAT)
Raw
Backup.bat
@ECHO OFF
SET DT=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2%
SET TM=%TIME:~0,2%-%TIME:~3,2%-%TIME:~6,2%
sqlcmd -U sa -P 123456 -S DSK02\SQLEXPRESS -d CAPP2 -Q "backup database CAPP2 to disk='C:\Backup\%DT% %TM%.bak' "
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment