The server that we want to be primary will failover to the secondary server but the databases/AGs will stay with that secondary server (marked as Primary) They do not Failback. I suspect it is because, in Failover Cluster Manager both are marked as Preferred Owners.
Figuring that it would be as easy as unchecking the secondary server so both are Possible Owners but only the primary server was a Preferred Owner would be the solution. Making this change (unchecking the secondary server) seems to revert back to both being selected as Preferred Owners. Sometimes in minutes, sometimes in a hour or more (not sure how long).
- am I on the right track, is the problem that the secondary server should NOT be a Preferred Owner?
- How do I correct this if the GUI is enforcing the original settings?
This has driven me to my wits end over a few months. Even considered setting up a nightly reboot to force failback.
Thanks in advance.