I have a bunch of SQL Servers installed on Windows2008R2. Currently, each windows server has two NIC's, each connecting to separate networks. In other words, each server appears on each network. One network allows the applications to access the database, the other network is intended to be used for large volumes of data being migrated between the servers without impacting the network the applications use.
I have a job that pulls in a large chunk of data from one SQL server to another. I would like that job to take advantage of the second network as well, but I am stumped.
Is there a way to tell SQL to use a specific network device when communicating to another server?