sql server 2000 Êý¾Ý¿âÔ¶³Ì±¸·Ý

EXEC sp_configure 'show advanced options', 1
declare @strdirname varchar(100)
declare @RemotePathstr varchar(100)
declare @LocalPathstr varchar(100)
declare @DBName char(50)
declare @sql varchar(100)
set @strdirname=replace(substring(convert(varchar(20),getdate(),120),1,10),'-','') --»ñµÃÈÕÆÚ
set @RemotePathstr = 'S:\ÆäËü·þÎñÆ÷±¸·Ý£¨ÖØÒª£©\60\center\'+'center_'+@strdirname+'.bak' --±¸·Ý·¾¶+ÃüÃû+±¸·ÝÈÕÆÚ
set @DBName= 'MMS_CENTER'
set @sql='del S:\ÆäËü·þÎñÆ÷±¸·Ý£¨ÖØÒª£©\60\center\'+'center_'+rtrim(convert(varchar,getdate()-3,112))+'.bak'
--Ìí¼ÓÍøÂçÇý¶¯Æ÷Ó³Éä
exec xp_cmdshell 'net use S: \\172.24.186.247\G$ "ÕâÀïÌîдÄãÁ¬½ÓÔ¶³Ì·þÎñÆ÷µÄÃÜÂë" /user:172.24.186.247\administrator'
--ʵʩ±¸·Ý
backup database @DBName to disk=@RemotePathstr
--ɾ³ý3ÌìÇ°µÄ±¸·ÝÎļþ
exec xp_cmdshell @sql
--ɾ³ýÓ³Éä
exec xp_cmdshell 'net use S: /delete'
RECONFIGURE
EXEC sp_configure 'show advanced options', 0
RECONFIGURE