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?
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?
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-DatabaseAvailabilityG roup
Restore-DatabaseAvailabili tyGroup
Start-DatabaseAvailability Group
Set-DatabaseAvailabilityGr oup
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.
Stop-DatabaseAvailabilityG
Restore-DatabaseAvailabili
Start-DatabaseAvailability
Set-DatabaseAvailabilityGr
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
partially answered.
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.