lundi 6 août 2012 09:15
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.
Toutes les réponses
lundi 6 août 2012 10:32
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
lundi 6 août 2012 10:54
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.
- Marqué comme réponse Shulei ChenModerator lundi 13 août 2012 08:52
lundi 6 août 2012 12:29Database 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