SQL2000异地备份
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
浙公网安备 33010602011771号