利用数据库计划进行数据库的异地备份

DECLARE
@FileName VARCHAR(200),
@CurrentTime VARCHAR(50),
@Copy Varchar(200),
@DEL Varchar(200)
SET @CurrentTime = CONVERT(CHAR(8),GETDATE(),112) + CAST(DATEPART(hh, GETDATE()) AS VARCHAR)

SET @FileName = 'D:\backup\' + @CurrentTime + '.bak'
--全备份
--BACKUP DATABASE miyun TO DISK = @FileName WITH NOINIT, NOUNLOAD, NAME = N'备份', NOSKIP, STATS = 10, NOFORMAT
--差异性备份
BACKUP DATABASE miyun TO DISK = @FileName WITH INIT,differential,retaindays=6
--映射异地备份盘
exec master..xp_cmdshell 'net use z: \\200.200.200.235\e$ "abc" /user:200.200.200.235\administrator'
--copy文件至备份盘
set @Copy='copy "'+@FileName+'" z:'
exec master..xp_cmdshell @Copy
--删除映射盘
exec master..xp_cmdshell 'net use z: /delete'
--删除本地存储备份文件
--set @DEL='del "'+@FileName
--exec master..xp_cmdshell @DEL