SQL2000异地备份代码：
exec master..xp_cmdshell
'net use z: //192.168.0.88/d$ "password" /user:192.168.0.88/administrator'
declare @a char(80)
select @a ='z:/' + replace(replace(convert(varchar(19),getDate(),120),' ','-'),':','-') + '-service_korea.bak'
backup database pubs to disk= @a
exec master..xp_cmdshell 'net use z: /delete'
'net use z: //192.168.0.88/d$ "password" /user:192.168.0.88/administrator'
declare @a char(80)
select @a ='z:/' + replace(replace(convert(varchar(19),getDate(),120),' ','-'),':','-') + '-service_korea.bak'
backup database pubs to disk= @a
exec master..xp_cmdshell 'net use z: /delete'
软件开发平台 FIX ES2007
www.founderfix.com
372
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
