My datacenter has a 100 MBPS network. I sit outside the Data center in a 10 MBPS network.
Here's the scenario:
The 42 GB dump of a database is on Server X within the 100 MBPS network
The restore has to happen on a server Y also within the same segment/network.
My computer Z in the 10 MBPS network within the same domain as the other two.
My seniors claim that when I restore this dump on server X to the server Y using the query analyzer from my machine Z it brings down the network bandwidth.
I am not sold on this. Is anybody else??
I have a staff meeting tomorrow, before which if I get this answer....I will really appreciate this.
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA