增加一条新的任务,其中执行代码部分如下:
DECLARE @filename VARCHAR(255);
DECLARE @date DATETIME;
DECLARE @path VARCHAR(255);
SELECT @date = GETDATE();
SET @filename = CAST(DATEPART(yyyy, @date) AS VARCHAR) + '_' + CAST(DATEPART(MM, @date) AS VARCHAR) + '_'
+ CAST(DATEPART(dd, @date) AS VARCHAR) +'_' +CAST(DATEPART(HH, @date) AS VARCHAR)+'_' +DateName(minute,GetDate()) +'.bak';
SET @path = N'd:\数据自动备份\XFY_' + @filename;
BACKUP DATABASE XFY TO DISK = @path;
调试时中间报错message未启动,安装网上的设置登录账号操作也还是有错误,很大程度上是写的sql有问题,先检查代码。