Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Bandwidth issues during restores

Author  Topic 

pareshmotiwala
Constraint Violating Yak Guru

323 Posts

Posted - 2001-07-09 : 10:25:56
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.

Regards
Paresh Motwiwala



   

- Advertisement -