Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Always On Message Spam Expand / Collapse
Author
Message
Posted Wednesday, February 20, 2013 9:04 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:31 AM
Points: 598, Visits: 1,607
Hi all

I am getting lots of:

The target database, 'XXX', 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.

Nothing should be trying to connect to the secondary, does anyone else experience this?

Thanks
Post #1422134
Posted Friday, February 22, 2013 7:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, August 28, 2014 8:22 AM
Points: 47, Visits: 263
"Nothing Should", but are you sure nothing is? Run a Profiler Trace against your secondary replica and ensure that is true.
Post #1423053
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse