After configuring the AlwaysOn Availability Groups on SQL Compliance Manager, review the following information to start auditing and modify your AlwaysOn databases.
Use the following steps to remove the listener from SQL Compliance Manager auditing.
Users can select all of the appropriate audit settings for each AlwaysOn database and export these settings as XML files. You then can import the files into the remaining instances or nodes in the group.
To import the audit settings to each node, click Import on the Summary tab. Choose the exported XML file, the information you want to import, and the servers to which you want to apply the settings. Select all the other servers in the availability group as the target for audit settings. After users apply the settings from the file, each member of their availability group is set to audit in exactly the same way as noted in the exported file. This process also allows you to add additional databases that are the part of an availability group on these servers.
To remove an AlwaysOn node from SQL Compliance Manager, first stop the agent service using the Failover Cluster Manager before attempting to remove a node instance from SQL Compliance Manager. This step must be performed if you may want to add back to SQL Compliance Manager the removed node using the Manual Deployment option without any agent deployment. In this case, ignore the error message that appears after you remove the node.
SQL Compliance Manager audits all activity on your server. Learn more >> IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal |