September 14, 2011 at 1:01 pm
Hi,
I've created a maintenance plan with a Maintenance Cleanup Task as a subplan.
In this Maintenance Cleanup Task :
I setup to delete "Maintenance Plan trace reports"
Folder:"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG"
File extension: trc
Checked: "Delete files based on the age of the file at task run time"
Set Delete files older than "2 Week(s)"
Looking at different articles some one suggested to upgrade to sp4 but if the functionlaity is built in why do you have to upgrade or apply a apatch ??????
All subplans are running successfuly, but the .trc files are NOT deleted in the ..\LOG folder.
Can someone tell me why and how to setup to delete the .trc files?
Thanks
September 14, 2011 at 1:51 pm
If you're talking about the 5 files of the default trace, there will only ever be 5. When SQL creates a new one, it deletes the oldest, so there's no need for any manual cleanup task.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 14, 2011 at 9:47 pm
There is a bug with the code that implmenets the maintenance plan task to delete files. You need to install the update to correct the bug.
September 15, 2011 at 12:48 pm
Both answers are correct, Gails is the most important in that there are only those files and they reused. If you are not at SP2 or higher you would see an issue with deleting backups files. You should at the very least be at SP3 even though SP4 is the last available update for 2005
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
September 13, 2012 at 7:02 am
Hello Gail, I know this post is old but what you mentioned relates directly to our issue. This isn't a major issue, just annoying. My customer has SQL 2005 SP4 Enterprise. As you said, the default .trc files total as 5 and rollover as designed. Back in August, for an unknown reason, two of the log files log_5194.trc and log_5195.trc stuck around and fell out of the 5 file cycle. So right now, we have the 5 default .trc files working as designed, but we have two extra .trc files from 22-Aug just sitting there. It won't let me delete because is says "file in use". I looked at sys.trace and it shows the only running trace as the current default trace file.
I'm guessing SQL service will have to be stopped in order to delete, but curious if you have any ideas. Thanks.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply