有没有命令可以删除备份集的？
------解决方案--------------------
备份时选择"覆盖现有所有备份集".
------解决方案--------------------
- SQL code
--删除过期的备份文件,每天两次declare @str varchar(100),@dir varchar(100),@fileName varchar(30)set @dir='del D:\DBtext\jgj\DBABak\'set @filename=left(replace(replace(replace(convert(varchar,getdate()-15,20),'-',''),' ',''),':',''),8)set @[email protected][email protected]+'*.bak'exec xp_cmdshell @strset @filename=left(replace(replace(replace(convert(varchar,getdate()-8,20),'-',''),' ',''),':',''),8)set @[email protected][email protected]+'*.diff'exec xp_cmdshell @strset @filename=left(replace(replace(replace(convert(varchar,getdate()-8,20),'-',''),' ',''),':',''),8)set @[email protected][email protected]+'*.trn'exec xp_cmdshell @str