Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question
    
Are these IP addresses on the same or different subnetworks? –  evilensky Dec 5 '11 at 19:26

2 Answers 2

Solution to your problem is to use different subnet for the second interface than the interface used to connect the application server. So that both the communications i.e source to application server and source to database server will be isolated from each other.

share|improve this answer

Assuming the source server is Windows, you could add a static route to the backup server via the second interface. example interface A 192.168.1.10, Interface B (for backups) 192.168.1.11. Backup server 192.168.1.50

from an elevated command prompt, type route print and take note of the Interface List at the top of the output. Identify the interface on which you want the traffic to leave so that it can replace the 'XX' in the command below:

route add -p 192.168.1.50 mask 255.255.255.255 192.168.1.11 IF 'XX'

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.