My default trace crashed because .... disk is full
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.
Is there a statement to just restart the default trace?
Or do I really need to script it from an existing file and start that one ?
Or do I really need to stop/start the SQLserver instance ?
I did find this in BOL: http://technet.microsoft.com/en-us/library/cc293615.aspx
but that doesn't give a simple solution.
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