SQL Audit in Always On Availability Group

  • Hello!

    I have setup SQL Audit in Always on Availability group (2 node) for ddl and dml to write to Event viewer. I have configured on both nodes using the same GUID. It writes to Event viewer in the Primary node (1) or when I fail primary and  and make secondary primary, it works.

    But, when I do select on secondary node using SSMS, it is not writing to the event viewer.

    Thanks in advance.

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • This was removed by the editor as SPAM

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

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