On a physical sql server box I have 4 NICs. 3 of the NIC’s are setup in a NIC team for increased throughput on user connections. I want to turn on the 4th NIC and have it isolated for database backup traffic only. If I give the 4th NIC an IP, how can I be sure that new user connections will not start using this NIC?
I have the ability to configure our third party backup tool (SQLsafe) to run backups over a designated IP. I’m just not sure how keep sql user connections from accessing it.
Physical box running Win2k8R2, SQL2k8SP1