File backup to dedicated nic

  • I've SQL Server 2019 Always On cluster (latest CU) that has 4 network adapters. Two of the are teamed as production network and two adapters for iSCSI networks. I'm using (hallengren.com) scripts for backup. The destination where backups are saved has same kind of network adapter configuration. Backups are working ok, but I wonder why I see heavy network traffic on all adapters during backup?

    Backup is configured to use only one adapter

    @Directory = '\\192.168.42.116\backup$\Staging',

    Production network has subnet 10.101.54.0/24

    iSCSI has subnets 192.168.42.0/24 and 192.168.43.0/24

    Using netstat on the destination server I can see that sessions are open from both adapters

    TCP 10.101.54.21:445 STAG-SQL-02:59488 ESTABLISHED

    TCP 192.168.42.116:445 iscsi1-stag-sql02:56823 ESTABLISHED

    Is there way to force backup to use only specific networks? The goal is to get backup traffic out of the production network

     

     

    Attachments:
    You must be logged in to view attached files.
  • MPIO (Multipath IO) is enabled on server. Could that be the reason for behavior?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply