2、 begin set@cmd1='ifexistE:DATABACKUP'+@dbname+convert(varchar(10),DATEADD(day,-@i,getdate()),112)+'*'+'del'+'E:DATABACKUP'+@dbname+convert(varchar(10),DATEADD(day,-@i,getdate()),112)+'*'execmaster..xp_cmdshell@cmd1----删除10天之前的数据库备份 set@i=@i+1end----备份数据库----execmaster..xp_c