Maintenance Cleanup Task can't delete trc files

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Maintenance Cleanup Task can't delete trc...

Maintenance Cleanup Task can't delete trc files

Rate Topic

Display Mode

Topic Options

Author

Message

allamiro

Posted Wednesday, September 14, 2011 1:01 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 14, 2011 4:13 PM
Points: 16, Visits: 41

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

Post #1175224

GilaMonster

Posted Wednesday, September 14, 2011 1:51 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:38 AM
Points: 37,726, Visits: 29,987

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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1175256

happycat59

Posted Wednesday, September 14, 2011 9:47 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:55 PM
Points: 2,471, Visits: 2,066

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.

Post #1175400

Meet George Jetson

Posted Thursday, September 15, 2011 12:48 PM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 7:51 AM
Points: 1,273, Visits: 1,204

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.

Post #1176012

louislamour2673

Posted Thursday, September 13, 2012 7:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:33 AM
Points: 5, Visits: 250

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.

Post #1358528

« Prev Topic | Next Topic »

Permissions