sql server异地备份
服务器名为：jiliangserver 备份的数据库为：JLSDB declare @strsql varchar(1000)declare @strdirname varchar(50)declare @strcmd varchar(50)declare @strsend varchar(1000)declare @strdate varchar(50)exec master..xp_cmdshell 'net use \\10.30.100.26\yfx$\jiliangbak jiliangserver用户的密码 /user:bydhq\jiliangserver'set @strsql='backup database JLSDB to disk=''\\10.30.100.26\yfx$\jiliangbak\'set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','')set @strcmd='md \\10.30.100.26\yfx$\jiliangbak\'--set @strcmd=@strcmd+@strdirnameexec master..xp_cmdshell @strcmd--print @strsqlset @strsql=@strsql+@strdirname+'jiliang.dat'' with init,nounload,noskip,noformat'--print @strsqlexec (@strsql)
页:
[1]