Mirroring on 2 windows servers with the same instance name on each server
Posted on 2013-01-15
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