SQL SERVER – Error: 566, Severity: 21 – An Error Occurred While Writing an Audit Trace. SQL Server is Shutting Down

Have you ever been in a situation where SQL Server shuts down by itself? It sounds strange but I met across a gentleman in flight who reported this issue to me. Since I was curious to know the cause, we exchanged our business cards. Once I came back home, I sent him an email asking more details about the SQL shutdown issue. Let us learn about how to fix error, An Error Occurred While Writing an Audit Trace.

This is a companion discussion topic for the original entry at https://blog.toadworld.com/2017/02/03/sql-server-error-566-severity-21-an-error-occurred-while-writing-an-audit-trace-sql-server-is-shutting-down