SQL Server 2012 Availability Groups Lessons Pt 3
This is the third tip for making your setup of SQL Server 2012 availability groups easier and complete. Tip 3: As part of a clients business requirements we are required to track every select, insert, update or delete that occurs.
We do this by using the audit functionality in SQL Server, so on our primary server we created a server audit and then in our database we created the audit specification. Now the synchronous failover server database has that audit specification but you need to create the same server audit on each server. So in this situation we had to create the server audit for each of the synchronous secondaries, one for failover and the other for reporting. By doing this you have complete auditing on failover and for reporting.