November 14, 2014 at 3:09 pm
TheSQLGuru (11/14/2014)
Yes, primary is the GOLD MASTER VERSION of the database. You can only have one of those, although it can move locations on failover. That is where transactional DML activity gets "mirrored" over to 1 or more secondary copies of said database.
It will go back to your design, you will have a specific node on a specific site which you deem as your Primary replica. Other nodes\replicas will then be added as secondarys.
Kevin has given some good info regarding the log send\replay, this is even more reason to segregate your mirror traffic (and that's essentially what it is) down separate networks. This will involve custom configuration of your mirroring endpoints but will provide extra benefits in respect of mirror traffic flow between replicas.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 20, 2014 at 6:06 am
Thanks, everyone. I appreciate all this information.
Viewing 2 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply