Maintenance Job does not remove .trn files
-
Windows 2003 Server
AD mixed mode
SQL2K SP3
My scheduled maintainance jobs are set to only keep files for the last three days.
The database .bak files are succesfully purged, but the .trn files are not. I have gone so far as to completely redefine the maintainance jobs, but I can never get it to remove the older .trn files.
What am I missing here?
-
I have had this problem with maintenance plans when I have gone in to modify them. I found I usually had to delete the problem plan and recreate it from scratch. I never found a reason for the issue.
hth.
-
Maintenance plans are somewhat flaky in my best experience.
http://www.sqlservercentral.com/columnists/aingold/workingaround2005maintenanceplans.asp
-
Thanks, this is extremely helpful!
Regards,
Joe
-
Just wait 'till you try them in SQL 2005, they're even worse !
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply