Actually, I query sys.traces to import the trace file to figure out file extends, ...
There is nomore info for trace id 1 !
No info at all because we are not tracing for other reasons either.
Then I searched SQLservers Errorlog and got the the errormessage stating the default trace ended because :
2009-02-12 15:44:20.880spid116Trace ID '1' was stopped because of an error. Cause: 0x80070070(There is not enough space on the disk.). Restart the trace after correcting the problem.
I don't know for sure about that time, but currently the disk (250GB) has 50GB free space.
I'm still trying to figure out what's been goin on, but for that server I'm just a "passer-by" who got called in to help out. So I'm in contact with the actual administrators to give me more input.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me