脚本：use master;
go
---声明变量
declare @dbName nvarchar(
max)
='MG_DATA';
declare @dbFullName nvarchar(
max)
='C:\Backup\MG_DATA_'+ convert(
varchar(
50),
getdate(),
112)
+'_'+ DateName(hour,
GetDate())
+DateName(minute,
GetDate())
+DateName(second,
GetDate())
+'.bak';
---备份数据库
DECLARE @kid varchar(
100)
SET @kid=''
SELECT @kid= @kid + 'KILL '+CAST(spid
as Varchar(
10))
FROM master..sysprocesses
WHERE dbid
=DB_ID(
@dbName)
PRINT @kid
EXEC(
@kid);
backup database MG_DATA
to disk=@dbFullName; 步骤：1.新建作业
2.
https://blog.csdn.net/u011127019/article/details/54141117
转载于:https://www.cnblogs.com/foreverfendou/p/8664463.html
