October 20, 2012 at 10:36 pm
Hi,
It seems the answer is no to this but I would like to confirm this.
I have three SQL 2005 servers and I would like to setup data base mirroring. Can I get one server and then create mirrors for all three SQL servers on a single server?
Thanks.
October 21, 2012 at 2:53 am
The way i'm reading it the scenario you have described is possible. You will have 3 principal instances with a principal database on each that use the 4th server as a mirror instance is that correct?
What you can't do is have 1 principal mirroring a database out to 3 mirror instances, this is only possible with AlwaysOn groups in SQL Server 2012.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2012 at 10:06 am
Thanks for your answer. Yes, you understood correctly. I actually spent few hours to create this in my lab and yes, I managed to create the mirrors for three different database (from multiple servers) to one server.
Thanks again.
October 21, 2012 at 10:52 am
No problem
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply