InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 17 Jun 2013 22:35:59 GMT20http://www.sqlservercentral.com/Forums/Topic1175224-1291-1.aspxHello 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.Thu, 13 Sep 2012 07:02:28 GMTlouislamour2673http://www.sqlservercentral.com/Forums/Topic1175224-1291-1.aspxBoth 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 2005Thu, 15 Sep 2011 12:48:30 GMTMeet George Jetsonhttp://www.sqlservercentral.com/Forums/Topic1175224-1291-1.aspxThere 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.Wed, 14 Sep 2011 21:47:55 GMThappycat59http://www.sqlservercentral.com/Forums/Topic1175224-1291-1.aspxIf 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.Wed, 14 Sep 2011 13:51:17 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1175224-1291-1.aspxHi, 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: trcChecked: "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?ThanksWed, 14 Sep 2011 13:01:45 GMTallamiro