database involved in availability group - showing state as online but it is synchronizing and does not accept connection - how can I find that out?
0
votes
2
answers
500
views
how can I find the list of databases I actually can connect to?
I am using sys.master_files to check the state of my database files
however, on the secondary, the database is synchronizing
and it is showing as ONLINE
I cannot do this:
use my_database
and I cannot do this:
select * from my_database.sys.master_files
> Msg 976, Level 14, State 1, Line 364 The target database, 'my_database',
> 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.
Asked by Marcello Miorelli
(17274 rep)
Mar 12, 2024, 10:41 AM
Last activity: Mar 12, 2024, 03:22 PM
Last activity: Mar 12, 2024, 03:22 PM