declare @i datetime;
--保留天数
set @i=CONVERT(varchar(100),getdate()-5, 23);
--删除过期文件
EXECUTE master.dbo.xp_delete_file 0,N'D:\Double-Backup',N'bak',@i
EXECUTE master.dbo.xp_delete_file 0,N'D:\Double-Backup',N'trn',@i