Post reply

Server Audit shut down server when 'continue' is set

  • July 5, 2016 at 10:16 am

    #400355

    Audit logs are being written to a drive that ran out of space. The audit is set for CONTINUE on failure, but the instance shut down anyhow.

    Under "Audit File Maximum Limit", the 'maximum rollover files:' button is enabled, but there's nothing checked underneath it.

    2 questions:

    1) Why would the instance shut down anyway?

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

    When the file parameters are adjusted, what table(s) get updated? I don't see a column in sys.server_audits, and sys.server_audit_specification_details

    and sys.server_audit_specifications

    are empty.

    SQL Server 2012, sp3 cu2

    thanks!

  • July 6, 2016 at 7:37 am

    #1888685

    Does the drive the log files are being written to contain any system db files? Or user db files?

    And is the drive truly full when this happens?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 2 posts - 1 through 1 (of 1 total)

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