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.
| Author |
Topic |
|
gangstaboy
Starting Member
1 Post |
 Posted - 2002-07-12 : 08:19:11
|
| We have 2 DB servers in the same workgroup: DB1 (live) and DB2 (backup). There is a job to backup the dbs on DB1 directly to DB2's shared folder. It works - but now it's slow down after the whole PC is reinstalled!! :-o This process is used to take about 1 hour (~14GB files), but now this process takes more than 10 hours on the same hardware!!! Why? We had to reinstall the OS and the SQL Servers too, but nothing else is changed...! Any idea? Thanks for your help! GangstaBoygangsta@maffia.hu |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-07-12 : 08:27:16
|
quote:
...but nothing else is changed...!
Well, my guess is that you are wrong about that....When backing up over a LAN, you are always at the mercy of the LAN throughput. Maybe your NIC isn't configured to fully utilize the bandwidth.<O> |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-13 : 11:35:42
|
| Check all your drivers are upto date and your NIC's are fixed at 100 MB rather than autosensing. Are both servers on the same switch ? Any network changes ?HTHJasper Smith |
|
|
|
|
|
|
Backup job is slow down :-(