Post reply

SQL Server Shutdown

  • July 23, 2009 at 6:17 am

    #72394

    Hi All,

    I have SQL Server 2000 with SP4.

    From last 1 week I am experiencing some issue with it.

    Whenever I start the SQL Server Services its shutting down after some time.

    When I check the error logs found below message:

    Error writing audit trace. SQL Server is shutting down.

    Can you please help me out to resolve this issue ?

    Thanks

    Thank You.

    Regards,
    Raghavender Chavva

  • July 23, 2009 at 6:34 am

    #1028891

    Have you Enabled C2 audit tracing?

    I think C2 audit tracing is enabled and SQL Server is not able to write to it due to lack of disk space or other issues like permission.

  • July 23, 2009 at 6:47 am

    #1028902

    Yes,

    C2 auditing is enabled.

    is that the cause for SQL Server shutdown ?

    Thank You.

    Regards,
    Raghavender Chavva

  • July 23, 2009 at 6:51 am

    #1028906

    BOL

    C2 audit mode saves a large amount of event information to the log file, which can grow quickly. If the data directory in which logs are being saved runs out of space, SQL Server will shut itself down. If auditing is set to start automatically, you must either restart the instance with the -f flag (which bypasses auditing), or free up additional disk space for the audit log.

  • July 24, 2009 at 5:45 am

    #1029573

    Thanks Suresh.

    It was due to space issue only.

    Thank You.

    Regards,
    Raghavender Chavva

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

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