Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Unanswered: SQL error 566 shutting down SQL server

    this is a copy of part of the error log about the SQL server being shut down. Does any one know of a fix, turning off the audit trace is not an option. THX for your help.

    keith


    • 2009-02-01 04:33:23.86 spid54 Error: 566, Severity: 21, State: 1.
    • 2009-02-01 04:33:23.86 spid54 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 SQL Server. If the problem persists, disable auditing by starting the server at the command prompt with the "-f" switch, and using SP_CONFIGURE.
    • 2009-02-01 04:33:23.87 spid54 SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    are you out of space? if yes, then get more space.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Aug 2008
    Location
    India
    Posts
    55
    Bring SQL server to single user mode

    Run the query
    select * from ::fn_trace_getinfo() will provide the details about all the traces running and kill unwanted .

    or

    Take SQL server to single user mode (refer support.microsoft.com for details)
    Run the following query analyser
    sp_configure 'c2 audit mode',1
    reconfigure with override

    or

    If u r still facing the issue
    Take SQL server to single user mode (refer support.microsoft.com for details)
    Run the following query analyser
    sp_configure 'scan for startup procs,1
    reconfigure with override

    If any audit is configured by you in this server , check whether its working properly after this since u r disabling startup procedure

    Reboot to check whether the problem prevails

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •