April 9, 2014 at 5:05 pm
To be a bit more clear, here is what Im asking;
Principal Server A has a database named db1
Principal Server B has a database named db 2
Mirror Server C is where I want to mirror the two databases to, so this server would hold ServerA.db1 and ServerB.db2
Is this possible ?
Can you please point out the major difference between mirroring in 2012 vs 2008 R2 ? I would like to set up the most simple mirroring, with no witness.
Thank you
April 9, 2014 at 8:09 pm
koln (4/9/2014)
To be a bit more clear, here is what Im asking;Principal Server A has a database named db1
Principal Server B has a database named db 2
Mirror Server C is where I want to mirror the two databases to, so this server would hold ServerA.db1 and ServerB.db2
Is this possible ?
Can you please point out the major difference between mirroring in 2012 vs 2008 R2 ? I would like to set up the most simple mirroring, with no witness.
Thank you
I don't think there were any changes to mirroring from 2008R2 to 2012, other than mirroring became deprecated. It won't be around after 2 more major versions. But there are a LOT of other changes and other than the licensing changes (per-core licensing instead of per-cpu license if you aren't using CAL licenses) I would not use 2008R2 if I had the opportunity to use 2012.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
April 10, 2014 at 5:10 am
I think,, it is possible since the mirroring is happing on different databases
Prinicipal Server A.db1 is being mirrored to Mirror Server C.db1
Prinicipal Server B.db2 is being mirrored to Mirror Server C.db2
April 10, 2014 at 6:12 am
Yes, this is possible as mirroring is specific to individual database and not specific to server.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply