EXEC sp_configure 'show advanced options', 1
declare @strdirname varchar(100)
declare @RemotePathstr varchar(100)
declare @LocalPathstr varchar(100)
declare @DBName char(50)
declare @sql varchar(100)
set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','') --获得日期
set @RemotePathstr = 'S:/其它服务器备份(重要)/60/center/'+'center_'+@strdirname+'.bak' --备份路径+命名+备份日期
set @DBName= 'MMS_CENTER'
set @sql='del S:/其它服务器备份(重要)/60/center/'+'center_'+rtrim(convert(varchar,getdate()-3,112))+'.bak'
--添加网络驱动器映射
exec xp_cmdshell 'net use S: //172.24.186.247/G$ "这里填写你连接远程服务器的密码" /user:172.24.186.247/administrator'
--实施备份
backup database @DBName to disk=@RemotePathstr
--删除3天前的备份文件
exec xp_cmdshell @sql
--删除映射
exec xp_cmdshell 'net use S: /delete'
RECONFIGURE
EXEC sp_configure 'show advanced options', 0
RECONFIGURE