June 15, 2011 at 2:41 am
I couldn't find a board dealing specifcally with SQL Connectivity, so I posted here. Please feel free to rdirect me if necessary.
I have 2 physical SQL boxes, each with 2 NICs. NIC1 on eaxch server links to the LAN, while NIC2 is a direct link between the servers.
Server 1
Win Server 2008 R2
SQL 2008 R2 Ent
NIC1 = 10.0.0.11
NIC2 = 10.0.1.11
Server 2
Win Server 2008 R2
SQL 2008 R2 Ent
NIC1 = 10.0.0.12
NIC2 = 10.0.1.12
We have an application that uses SQL as a datastore. The client's network is seriously overloaded, and we want to keep any unnecessary traffic off the LAN. The idea here is that SQL traffic in/out of the servers will be on NIC1 (The application config on each client has been set to use a specific IP, so the loads are manually balanced). Merge replication has been set up between the instances. SSRS is also done off Server2.
Is there a way to force the replication to use the direct link (NIC2/10.0.1.xx) ?
Regards
Des Norton
June 15, 2011 at 2:49 am
See this http://stackoverflow.com/questions/629907/how-to-set-network-adapter-used-by-sql-server-replication post that explains the in and out of setup.
-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
June 15, 2011 at 2:55 am
June 15, 2011 at 3:31 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply