批处理一键备份sqlserver数据库

@echo off

set "server_name=."
set "database_name=MyDB"
set "backup_path=D:\test"

REM 获取当前日期和时间
set dt=%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%

echo 正在备份数据库 %database_name% 到 %backup_path%...

sqlcmd -S %server_name% -Q "BACKUP DATABASE [%database_name%] TO DISK = N'%backup_path%\%database_name%_%dt%.bak' WITH INIT, FORMAT"

if %errorlevel% neq 0 (
    echo 备份过程中发生错误。
) else (
    echo 数据库备份已完成。
)

pause