September 7, 2015 at 6:32 am
Principal @ site 1.
Witness & Mirror @ site 2.
Comms issue between 1 & 2.
----------------
I have a system set up like this (by someone else) & no test system. I'm trying to work through the possible scenarios & solutions. Appreciate your responses.
September 7, 2015 at 6:53 am
If the connection between Site1 and Site 2 drops, principal will go offline (it doesn't have quorum), Mirror becomes new principal.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2015 at 7:03 am
Thanks Gail.
This is only a hypothetical but am I right in saying that it would not be possible to manually fail back until the comms issue was resolved?
ie.
remove the witness.
fail back.
September 7, 2015 at 7:06 am
snomadj (9/7/2015)
This is only a hypothetical but am I right in saying that it would not be possible to manually fail back until the comms issue was resolved?
That is correct.
You could manually bring the old principal online but that would be a last resort
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 7, 2015 at 7:06 am
With the network down, you won't be able to do a controlled failover.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 7, 2015 at 7:12 am
Much obliged!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply