SQL Server is shutting down

  • 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.

  • 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

  • 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.

  • 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

  • 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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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