SQL Server is shutting down

Question

Post reply

SQL Server is shutting down

denfordm

SSC Veteran

Points: 208
More actions
February 16, 2009 at 10:23 am

#130951

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.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135262 More actions · Answer 1

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

denfordm SSC Veteran Points: 208 More actions · Answer 2

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.

Johan Bijnens SSC Guru Points: 135262 More actions · Answer 3

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.