Hello all,
What is the latest after SP2 on the Maintenace Cleanup Task?
Has anyone been able to successfully delete old backup files(*.bak) and tran logs (*.trn) TOGETHER using maintenance plan cleanup task in SQL 2005 SP2 with all the htfixes instaled? .
In other words can EXECUTE master.dbo.xp_delete_file 0,N'D:\backups',N'bak',N'2007-07-12T10:12:03',1 be used with bak and trn at the same time
Thanks in advanced
This has been fixed in the latest cumulative update for SQL Server. Contact Customer Support and they will direct you to the fix.
jkh
No comments:
Post a Comment