April 25, 2016 at 6:59 am
Hi
Could any one help me on this.
i want to configure sql mirroring (HA) from two different location
eg: one from america and another from europe
so what my question is did i need to create linked server two combine these two servers and then configure mirroring?
or no need to create linked server ?
or is there any alternative
April 26, 2016 at 12:49 pm
If both the server are communicating each other. You can proceed with standard process
April 26, 2016 at 1:02 pm
You may want to review the legal issues involved if you are considering mirroring PII information from the EU to the US.
April 28, 2016 at 10:45 pm
There is no need of Linked Server to configure Mirroring between two databases on different instances.
You just need to check these points:
There is connectivity between both the instances.
Both the instances are using same version of SQL Server(like you can configure Mirroring between SQL Server 2008 and 2012, however it will only work if 2008 is primary and till first failure. As soon as 2012 becomes Primary after first failure, the mirroring will break and cannot be configured.)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply