patternsqlMinor
SQL Audit and AlwaysOn Replicas
Viewed 0 times
replicassqlauditandalwayson
Problem
We would like to enable SQL Audit on a SQL Server 2014 database. This database is replicated to a read replica via AlwaysOn. We don't need, or want, the replica audited. If we enable audit on the main database, will it automatically get replicated to our replica? If so, is there a way to prevent this?
Solution
Reference: SQL Server Audit (Database Engine)
If we enable audit on the main database, will it automatically get
replicated to our replica?
No it will not automatically get replicated.
The Database Audit Specification object also belongs to a SQL Server audit.
The Server Audit Specification object belongs to an audit. You can create one server audit specification per audit, because both are created at the SQL Server instance scope.
If we enable audit on the main database, will it automatically get
replicated to our replica?
No it will not automatically get replicated.
The Database Audit Specification object also belongs to a SQL Server audit.
The Server Audit Specification object belongs to an audit. You can create one server audit specification per audit, because both are created at the SQL Server instance scope.
Context
StackExchange Database Administrators Q#195942, answer score: 4
Revisions (0)
No revisions yet.