Monday, August 06, 2012 9:15 AM
Is it possible that I can make database mirror with more than 2 partners.
So when Partner_A(Principle) goes down then Partnet_B(Mirror to Principle) will up.
Partner_B(Principle) goes down then Partner_C(Mirror to Principle) will up.
Partner_C wil goes down then Partner_D(Mirror to Principle) will up.
is it possible?logically i think yes but I'm stuck at witness server and if meanwhile time 2 principle server will up which will be on 1st priority.
Guys plz suggest me some thing.
With Thanks & regards.
Monday, August 06, 2012 10:32 AM
as witness server is used only for automatic failover,
the Basic tip of Database mirroring is that 2 databases will have communication by ports with synchronous and asynchronous activity,which means high performance and high availability,
Partner A principle---------Partner B (mirrored database is in no-recovery mode in which no user connection will be done
if you want to have 1 Principle and more number of Mirrored Servers then use Log Shipping.
Ramesh Babu Vavilla MCTS,MSBI
Monday, August 06, 2012 10:54 AM
It is not possible with mirroring. you may take a look on the Availability Groups, replicas (Always ON) in SQL Server 2012.
I hope it helps.
There are 10 type of people. Those who understand binary and those who do not.
- Marked As Answer by Shulei ChenModerator Monday, August 13, 2012 8:52 AM
Monday, August 06, 2012 12:29 PMDatabase Mirroring is designed to have just one Mirror Partner. You should consider SQL 2012 Always On feature since it allow you to have up to 4 replicas