yidibakup 异地备份的代码

yidibakup 异地备份的代码

declare @strsql varchar(1000)

declare @newstrsql varchar(1000) declare @strdirname varchar(50) declare @strdirname2 varchar(50) declare @strcmd varchar(50) declare @strcmd2 varchar(50)declare @strsend varchar(1000) declare @strdate varchar(50) use masterexec master..xp_cmdshell 'net use \\192.168.0.10 "admin" /user:admin' set @strsql='copy e:\backup\*.* \\192.168.0.10\beifen\' set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','')+'16'set @strcmd='md \\192.168.0.10\beifen\' set @strcmd=@strcmd+@strdirname set @strdirname2=replace(substring(convert(varchar(20),getdate()-3,120),1,10),'-','')+'16'+'\*.*'set @strcmd2='del /s/q \\192.168.0.10\beifen\'+@strdirname2select @strcmd2exec master..xp_cmdshell @strcmd2 exec master..xp_cmdshell @strcmd --print @strsql set @strsql=@strsql+@strdirname--select @strdirnameselect @strcmdselect @strsql----print @strsql exec master..xp_cmdshell 'del /s/q e:\backup\*.*'backup database flgl to disk='e:\backup\flgl.bak'backup database mt1223 to disk='e:\backup\mt1223.bak'backup database middle to disk='e:\backup\middle.bak'backup database pmnetwork to disk='e:\backup\pmnetwork.bak'---backup database middle to disk='e:\backup\middle.bak'exec master..xp_cmdshell @strsql

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。