Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
robvolk
Most Valuable Yak
15732 Posts |
 Posted - 2011-06-16 : 16:05:00
|
| I'm trying to set up mirroring between 2 sites (Delaware and New York). We have T1 and T3 connections between them. We'd like to set up mirroring to use the T3 primarily, but fall back to the T1 if it goes away.From what I've gathered this is only possible at the routing layer/level, and would probably require some kind of virtual IP that can be redirected based on circuit availability. In other words, outside the scope of SQL Server and Windows, and likely only in networking hardware.Has anyone done something like this, or can point me to a resource? I've been reading this:http://sqlcat.com/whitepapers/archive/2007/11/19/sap-with-microsoft-sql-server-2005-best-practices-for-high-availability-performance-and-scalability.aspxBut they don't seem to mention redundant networking paths.Thanks. |
|
|
|
|
|
Mirroring over 2 network circuits