Information of Mirror servers

Question

Question

Joan Cruz · May 7, 2018

Hi

I'm using this query "Config.MapMirror.List" To get information of the list of servers that are in the mirror system.

I'd like to know how can I know which of the list is the primary and which is the failover or async member.

Is there a way to do it with this query? Is there another query to get this info?

Thanks a lot

Discussion (3)3

Log in or sign up to continue

Alexey Maslov · May 7, 2018

Hi Joan,

It seems that the right way to perform this task would be using MemberStatusList query of the class SYS.Mirror. See Documatic for details.

HTH.

1 0

score 0 · Answer 1 · 2018-05-08T08:45:41-04:00

Finally I used a mix between MemberStatusList query of the class SYS.Mirror and Config.MapMirrors:List to get all complete information.

Thank you

score 0 · Answer 2 · 2020-01-30T06:48:30-05:00

Can you tell me how you managed to get the information?

I am trying to do something similar but to show the information in a CSP page.

Best Regards,

Joao Palma