none
SQL Audit - Start Failure: Audit: Server Audit: 65536, Initialized and Assigned State: START_FAILED RRS feed

  • Question

  • Fellow SQLers,

    Doing a proof-of-concept with SQL Audit using SQL 2016 Dev Edition

    My SQL Audit was running and SQL Audit Spec was running. Noticed it had not collecting anything for days. Saw a start error in the SQL Error Log.

    I stopped the SQL Audit Spec and Stopped the Sql Audit.  Copied the audit log files off so we could start fresh.

    Started SQL Audit then started SQL Audit Spec.

    Noticed the following to entries in the SQL Log File after my restart:

    First Message - Audit: Server Audit: 65536, Initialized and Assigned State: START_FAILED

    Immediately followed by this message:
    Audit: Server Audit: 65536, Initialized and Assigned State: STARTED

    It is collecting fine now.

    What could cause a Start_FAILED with this message immediately followed by a STARTED?

    Thoughts?

    MG


    • Edited by mg101 Wednesday, July 17, 2019 6:59 PM wording
    Wednesday, July 17, 2019 6:59 PM

All replies