C2 auditing with disabling "is_shutdown" option RRS feed

  • Question

  • Hi folks,

    I have a requirement  to enable C2 auditing which will create audit log files. But, I do not want the option "is_shutdown", which will put down sql services when it is not able to write to audit files.

    Is it possible ???

    Jay N Shah

    Friday, July 26, 2013 3:31 PM


  • The only option is to move the trace files to another drive periodically. Else C2 auditing is designed to run until SQL Server is shutdown.

    Also this feature will be removed in the future versions of SQL Server. More details here

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @PradeepAdiga

    • Proposed as answer by Sofiya Li Sunday, July 28, 2013 11:52 AM
    • Marked as answer by Sofiya Li Friday, August 9, 2013 3:11 PM
    Friday, July 26, 2013 7:40 PM

All replies