MSSQL 异地备份----测试成功

exec master..xp_cmdshell 'net use \\10.5.24.9\framsdb unipecrisk /User:remotehost\frams0917'
go

declare @sql varchar(500),@ss varchar(500)
select @ss = substring(convert(varchar(10),getdate(),108),1,2)

select @sql='\\10.5.24.9\framsdb\Frams0917BackUp\'+'db_'+convert(varchar(10),getdate(),112) +@ss+'.bak'
--select @sql
--exec master..xp_cmdshell '\DBBackUp\Frams0917BackUp'
backup database Frams0917 to disk=@sql

--declare @sql varchar(500)
select @sql='del '+'\\10.5.24.9\framsdb\Frams0917BackUp\'+'db_'+convert(varchar(10),dateadd(day,-7,getdate()),112) +@ss+'.bak'
--select @sql
exec master..xp_cmdshell @sql --删除7天前的备份，也就是只保留7个最新备份
go