Home Dashboard Directory Help

ErrorLog flooded with Logon message by PrinceLucifer



Sign in
to vote
Type: Suggestion
ID: 776566
Opened: 1/15/2013 12:03:00 AM
Access Restriction: Public


I have asked for this before in the context of mirroring, now I am back with AlwaysOn: About 90% of my ErrorLog looks like this:
The target database, 'xxxxxx', 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 databases in the availability group, enable read access to one or more secondary availability replicas in the group. For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.

Why does it look like this? Because we have monitoring jobs that run SMO queries against that server... The first statement in those DB checks is if the DB is online. Unfortunately when you access the IsOnline property in SMO the system queries the DB in the background for all the properties, leading to this errormessage in the log.
I know that I can disable the logon error messages all together, but this is not really feasible as it would mean that I loose all the "real" logon failures as well (bad password, Kerberos errors, etc.)
Sign in to post a comment.
Sign in to post a workaround.