February 16, 2009 at 10:23 am
Does anyone have a solution to this?
An error occurred while writing an audit trace. SQL Server is shutting down. Check and correct error conditions such as insufficient disk space, and then restart the SQL server.
SQL Trace was stopped due to server shutdown.
I am saving to volume C and have 255 GB of free hardware space so why does SQL shut for insufficient disk space? please help.
February 16, 2009 at 10:41 am
Which is the location sqlserver is trying to write the audit trace file to ?
By default that would be the sqlserver instance \log folder (where you can also find errorlog, ...)
You should be able to find that in the errorlog file.
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
February 16, 2009 at 11:12 am
I am saving to: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
I have over 250 GB of free space; I always move the old race files to the network drive and yet the trace files shuts down the SQL Server.
I checked on Google and many people are facing the same problem but it seems no one knows the solution to this default audit trace behavior.
If someone has a solution please share, our Database is going down once every week.
February 16, 2009 at 11:48 pm
it states
Check and correct error conditions such as insufficient disk space, and then restart the SQL server.
the such as is the tricky part overhere.
I would start perfmon and check for C-drive wait times... if you drive is to busy, it cannot keep up with writing the audit trace file, hence sqlserver will have doubts the audit trace records all info, and so shut itself down.
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
February 17, 2009 at 12:17 am
Please post in an appropriate forum in the future. The article discussion forums are for article discussions
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply