Auditing in a high availability system

Configure a companion for auditing the same way you configure a server that does not use failover. For more information, see “Setting auditing options”.

All updates to user and security information (for example, sp_addlogin, sp_addrole, and so on) are performed on both the systems in transactional fashion. This keeps the user and security data identical on both companions.

For the following auditing parameters, both companions must be configured identically. These parameters are checked as a quorum attribute, or when explicitly listed with do_advisory: