rdbconcepts
asked on
Mirroring on 2 windows servers with the same instance name on each server
Hi
Please can anyone tell me if there are issues with creating mirrored SQL Server 2008 R2 instances that have the same instance name?
I have been asked to create the following;
Server1\Instance1 mirrored to Server2\Instance1
Server3\Instance2 mirrored to Server2\Instance2
Server4\Instance3 mirrored to Server2\Instance3
In addition, another instance will be installed on server2 for logshipping purposes from the production servers.
Other than any potential impact with IO/networking etc - are there any issues with doing this?
Many thanks for your help
Sue
Please can anyone tell me if there are issues with creating mirrored SQL Server 2008 R2 instances that have the same instance name?
I have been asked to create the following;
Server1\Instance1 mirrored to Server2\Instance1
Server3\Instance2 mirrored to Server2\Instance2
Server4\Instance3 mirrored to Server2\Instance3
In addition, another instance will be installed on server2 for logshipping purposes from the production servers.
Other than any potential impact with IO/networking etc - are there any issues with doing this?
Many thanks for your help
Sue
ASKER
Hi
Are you saying that I should not use mirroring then?
The business took the decision to do their DR using mirroring and log shipping. Not replication.
Sue
Are you saying that I should not use mirroring then?
The business took the decision to do their DR using mirroring and log shipping. Not replication.
Sue
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks - That is a great document and I hadnt seen it as yet.
My original question still wasnt answered in it though - would it be a problem if the mirror and secondary instances had the same name?
(This is so when they fail over, the applications only need very minor changes to swap them to the secondary db)
I suspect that the lack of a warning about doing this implies it is okay (which seems to be ms's way), but I would really appreciate knowing if anyone has done this sucessfully or not.
Many thanks,
Sue
My original question still wasnt answered in it though - would it be a problem if the mirror and secondary instances had the same name?
(This is so when they fail over, the applications only need very minor changes to swap them to the secondary db)
I suspect that the lack of a warning about doing this implies it is okay (which seems to be ms's way), but I would really appreciate knowing if anyone has done this sucessfully or not.
Many thanks,
Sue
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ill be doing this, this week so will reply back as to whether it works or not.
Thanks for your comments
Sue
Thanks for your comments
Sue
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your help - its working fine with the matching instance names - though it does make me check a lot more that Im in the correct instance when I do things!!
http://www.codeproject.com/Articles/215093/Replication-in-MS-SQL-Server