Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lw1990
Yak Posting Veteran
85 Posts |
 Posted - 2008-03-24 : 11:04:11
|
| Hi I have a problem in my SQL Server 2005. This morning I got a message of "Low Disk Space" in the drive "C" of a virtual machine, when I looked at the directory: C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\Data\MSSQL.4\MSSQL\Data I found 454 sql server profiler - trace data files in that folder, one of them like this one: audittrace20080207220657_13.trc takes 204,800KB, and totally takes 89GB in that folder. That's why I got "Low Disk Space"I know that we need profiler to troubleshoot data, view the event...butthese kind of .trc files were keep created in the "Data" folder in every 2 hours everyday and soon it will takes all the hard drive in the server. Is there anything I can set in SQL Server 2005 or other settings to delete the profile over 1 week or so automaticlly to free the space in the server?Thanks. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-24 : 11:10:33
|
| create a scheduled job in sql server or create a little app to delete stuff and schedule it with windows scheduler._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-03-24 : 13:23:33
|
| You could consider saving them onto another drive, then managing that drive separatelyJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
SQL Server Profiler