sql server 删除过期的文件

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