Database mirror with more than 2 partners

Question

Hi Guys,

Is it possible that I can make database mirror with more than 2 partners.

like Partner_A,Partner_B,Partner_C,Partner_D.

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.

Rahul

Answer 1

no,

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

Answer 2

Hi,

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.

Janos

---

There are 10 type of people. Those who understand binary and those who do not.

My Blog | Hire Me

Answer 3

Database 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

---

Javier Villegas | @javier_vill | http://sql-javier-villegas.blogspot.com/

Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you