备份数据库bat文件

echo off cls echo -- BACKUP DATABASE -- :输入数据库实例名 set /p SERVERNAME=Enter DB server name: :输入需要备份数据库名称 set /p DATABASENAME=Enter DB name: :输入数据库用户名 set /p USERNAME=Enter DB username: :输入数据库密码 set /p PASSWORD=Enter DB password: set BACKUPFILENAME=%cd%\%DATABASENAME%.bak :在bat统计目录下会创建bak备份 cd .>%DATABASENAME%.bak echo. sqlcmd -U %USERNAME% -P %PASSWORD% -S %SERVERNAME% -d master -Q "BACKUP DATABASE [%DATABASENAME%] TO DISK = N'%BACKUPFILENAME%' WITH INIT , NOUNLOAD , NAME = N'%DATABASENAME% backup', NOSKIP , STATS = 10, NOFORMAT" echo. pause