File share Quorum Windows Server 2012 R2 + SQL 2014 AlwaysOn AG


3 cluster nodes (2 in primary , 1 in dr)

2 nodes in primary site alwayson & auto failover (synchronous )

1 node in dr site alwayson & manual failover (synchronous )

we using file share witness under primary site.

each site has own subnet.

if have network issues between 2 sites or decided break link between 2 sites testing purpose.

how can make sure dr act primary db , once network link how convert primary site primary again.


hussain


hi hussain,

>>how can make sure dr act primary db , once network link how convert primary site primary again.

as far know, cluster choose node failover role automatically.

you allow failback role, failback preferred role. open properties of role , see option.

besides, considering running sql, post in following forum see if know details:

https://social.technet.microsoft.com/forums/sqlserver/en-us/home?forum=sqldisasterrecovery

best regards,

leo


please remember mark replies answers if help.
if have feedback technet subscriber support, contact tnmff@microsoft.com.




Windows Server  >  High Availability (Clustering)



Comments

Popular posts from this blog

Edit Group Policy

Hyper-V VM not reaching OS 'Logon' screen

DNS question...