Link to home
Start Free TrialLog in
Avatar of vegas588
vegas588

asked on

2 Node DAG Not Working as Expected

A client has a 2 node DAG, with each node in a different AD site and different physical site. Active/Passive sites. Each site also has 1 combined CAS/HUB server. The DAG is in DAC mode (DagOnly). There is some odd behavior in the cluster and we spent a good deal of time trying to figure out the issue. Am I correct in thinking that we should not be able to just move the active database copy to the DR site? We should have to go through the entire Datacenter failover scenario using the cmdlets as defined here: http://technet.microsoft.com/en-us/library/dd351049.aspx

Also, in the cluster resources, I see the primary FSW and the Alternate FSW. Yet, in my lab that I setup to mimick their environment, I only see the primary FSW. Should the alternate FSW be listed in a normal setup?

Avatar of Radweld
Radweld
Flag of United Kingdom of Great Britain and Northern Ireland image

A file Share Witness is required for a cluster with an even number of nodes, in the event of a failure of the primary node, the cluster will be left with an odd number and thus an FSW is not required to ensure quorum. In your DAG, the FSW should be in the primary site, with the normally active DAG node.

When DAC mode is enabled, the databases are not supposed to automatically activate in the event of a failure however your are not limited when manually activating a database copy hosted on the other node.  If you are manually activating a copy then this should come live and this is expected behaviour.
Avatar of vegas588
vegas588

ASKER

I'm not sure I understand completely. In their setup, we have no need to use the commands from that article becuase I can activate the databases whenever I want to. This would mean there is no point to all of those commands:
Stop-DatabaseAvailabilityGroup
Restore-DatabaseAvailabilityGroup
Start-DatabaseAvailabilityGroup
Set-DatabaseAvailabilityGroup

Are you saying that these commands will play no role for them, because that is what i am seeing? If we reboot the primary CAS server or if we reboot the primary DAG Mailbox server, the databaes automatically failover.
ASKER CERTIFIED SOLUTION
Avatar of vegas588
vegas588

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
partially answered.