-- 定义需要备份的数据库
DECLARE @backupDatabase VARCHAR(20) = 'DMS'
-- 定义数据库备份文件存放的基础路径
DECLARE @backupBasePath VARCHAR(MAX) = 'C:\'
-- 定义备份文件名,文件名格式:<DB>_backup_<yyyyMMdd>_<HH:mm:ss.SSS>.bak
DECLARE @backupFileName VARCHAR(50) = NULL
-- 获取当前时间戳
DECLARE @backupTime DATETIME = CURRENT_TIMESTAMP
-- 处理备份文件名称
SET @backupFileName = CONVERT(VARCHAR(25), @backupTime, 112) + '.bak'
-- 处理完整的备份文件路径
SET @backupBasePath = @backupBasePath + @backupFileName
-- 执行备份
BACKUP DATABASE @backupDatabase TO DISK = @backupBasePath
set date=%date:~0,4%%date:~5,2%%date:~8,2%
echo 2>C:\%date%.bak
echo 2>C:\%date%.txt
sqlcmd -S DESKTOP-R860OAM\SQLEXPRESS -U sa -P 123456 -i ./sql.sql -o C:\%date%.txt
如果权限不够
需要在开头加上以管理员身份运行
@echo off
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"
if '%errorlevel%' NEQ '0' (
goto UACPrompt
) else ( goto gotAdmin )
:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"
"%temp%\getadmin.vbs"
exit /B
:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )