Post reply

SQL Server is shutting down

  • February 7, 2011 at 10:46 am

    #142292

    SQL Server is shutting down, I got this error in my logs, how would I know is it sql server agent or sql server it is self.

    Thank you

  • February 7, 2011 at 10:49 am

    #1283306

    Can you post the exact message ?

    Do you mean the SQL services stopped, or the entire server shut down ?

  • February 7, 2011 at 11:01 am

    #1283316

    2011-02-04 05:00:27.93 spid94 Error writing audit trace. SQL Server is shutting down.

    2011-02-04 08:18:41.43 server SQL Server is starting at priority class 'high'(4 CPUs detected).

    2011-02-04 08:18:41.59 server SQL Server configured for thread mode processing.

    2011-02-04 08:18:41.60 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

    2011-02-04 08:18:41.74 server Attempting to initialize Distributed Transaction Coordinator.

    2011-02-04 08:18:43.38 spid3 Starting up database 'master'.

    2011-02-04 08:18:43.82 spid3 0 transactions rolled back in database 'master' (1).

    2011-02-04 08:18:43.82 spid3 Recovery is checkpointing database 'master' (1)

    2011-02-04 08:26:27.43 spid23 Recovery of database 'DatabaseName' (19) is 100% complete (approximately 0 more seconds) (Phase 2 of 3).

    2011-02-04 08:26:27.43 spid23 711 transactions rolled forward in database 'database1'(19).

    2011-02-04 08:30:04.73 spid3 Recovery complete.

    2011-02-04 08:30:04.73 spid3 SQL global counter collection task is created.

    2011-02-04 08:30:04.76 spid3 Launched startup procedure 'sp_MSrepl_startup'

    2011-02-04 08:30:04.76 spid3 Launched startup procedure 'sp_MScleanupmergepublisher'

    2011-02-07 11:59:09.05 spid98 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

  • February 7, 2011 at 11:35 am

    #1283337

    Please check if you have C2 Audit enabled on the instance.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 7, 2011 at 11:45 am

    #1283342

    How can I check that?

  • February 7, 2011 at 11:56 am

    #1283348

    go to server--> properties -->security--> enable C2 audit tracing...

    it shouldnt be checked.

    Regards,

    Sushant

    Regards
    Sushant Kumar
    MCTS,MCP

  • February 7, 2011 at 11:59 am

    #1283352

    You can check it through sp_configure or through SSMS GUI as in the below screenshot.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 7, 2011 at 12:00 pm

    #1283356

    Yes,

    it checked, so if I disabeled it, it would stop my tracing right is anything else would be damaged?

  • February 7, 2011 at 12:03 pm

    #1283357

    Check if it was enabled for any legitimate reason. Disabling it would not damage anything. C2 audit will continue to run until the drive hosting the trace file gets full. I had a similar experience as posted here[/url].

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 7, 2011 at 12:07 pm

    #1283359

    I don't have any one to check why it was checked,but I just disabeled, also when I run this statment:

    select * from ::fn_trace_getinfo(default)

    I get:

    traceid property value

    116

    12D:\\audittrace_20110207135814

    13200

    14NULL

    151

    Is this mean my trace is running or not?

  • February 7, 2011 at 12:11 pm

    #1283360

    As per the output the C2 audit trace is still running. After disabling it, the SQL Server service needs to be restarted in order for the changes to take effect.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 7, 2011 at 12:20 pm

    #1283371

    How do you know that is running?

  • February 7, 2011 at 12:22 pm

    #1283374

    Krasavita (2/7/2011)

    How do you know that is running?

    The output says so.

    D:\\audittrace_20110207135814

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • February 7, 2011 at 12:34 pm

    #1283381

    Thank you

  • February 8, 2011 at 8:35 am

    #1283749

    I rebooted sql services today and no trace running anymore,but SQL Server Agent services was not running again. What else should I check that causing this issue.

    Thank you

Viewing 15 posts - 1 through 15 (of 30 total)

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