Viewing 3 posts - 1 through 3 (of 3 total)
Hi,
You could left join to the sys.dm_hadr_database_replica_states view and interrogate the is_primary_replica column. This view only returns rows for database that participate in an always on availability...
April 13, 2018 at 7:01 am
Hi, you register the virtual cluster name not the individual nodes.
September 14, 2016 at 1:13 am
Recently did this using a Powershell script. There's loads of examples in google how to iterate through all your servers / databases to query the attributes you want.
October 28, 2015 at 2:57 am
Viewing 3 posts - 1 through 3 (of 3 total)