Hi forum!
I'm monitoring SQL 2012 Always On Groups with the latest SQL MP. A couple of the database replicas are configured to not allow access. This is to avoid additional license costs for those minor important databases.
However, I get the following events in the SQL log:
Error 976, Severity 14
The target database, '%.*ls', is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other ...
Of course, as soon as I configure read-only for those databases the events disappear.
Is there any other solution?
Has anyone identified already (all) the accessing workflows?
Thanks in advance,
Patrick