I want to copy database backup from my running DB Server to Backup server. The source server has two LAN cards connected through their own IP address. One LAN card is used to connect to the application server and I want to user the other LAN card to transfer the backup to the backup server so that it may not affect the performance of running applications.
I cannot run any job on destination server to pull the data from the source server and all the job have to run from source server. Could anyone inform me if there is any way to specify the specific IP address of source server through which I can copy the backup to the backup server?
Any solution like SSIS or Batch file will work.