Networking Forums

Networking Forums > Computer Networking > Windows Networking > Direct SQL Backup is very slow over the LAN

Reply
Thread Tools Display Modes

Direct SQL Backup is very slow over the LAN

 
 
Shekhar
Guest
Posts: n/a

 
      04-07-2008, 08:05 AM
Hi,

Within LAN I have a Computer (A) where I have all my SQL Server Databases
and I have another Computer (B) where I want to take backup of these
databases. From B, I connect A and issue BACKUP DATABASE statement to write
backup file in B like this:

BACKUP DATABASE xxx TO DISK = '\\B\D\Backup\xxx.bak'

The Computer B has got upgraded recently to double the size of HDD. Earlier
it was with 250 X 6 RAID and now it is 500 X 6 RAID. A 25 GB database file
took the following time to backup:

(a) Backup within A - 18 min
(b) Backup from A to B before recent upgrade - 20 min
(c) Backup from A to B after recent upgrade - 2 Hours & 30 min
(d) Backup within B - 24 min

Both A and B have similar confuguration like Windows 2003 R2 O/S, 4 GB RAM,
3.6 GHz CPU, Network Card etc. However, a remote iSCSI device had been added
to B for some other backup purpose and I believe it has nothing to do with
this performance issue.

I do expect the time count similar/near to (b) above even after the upgrade.
What could have gone wrong during the upgrade? Can anyone help?

Regards,
Shekhar.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exceptionally slow ping times, slow DNS lookup and slow download on router Martin Underwood Broadband 1 01-24-2007 12:05 AM
Slow wifi download compared to direct connect cmdrdata Wireless Internet 1 08-02-2006 10:24 PM
Slow Backup throughput Damon Johnson Windows Networking 3 05-20-2006 02:22 PM
Full daily backup with MS backup on W2k3 Herm Windows Networking 4 12-21-2004 01:45 PM
Two PCs direct? ph Windows Networking 2 04-25-2004 01:14 PM



1 2 3 4 5 6 7 8 9 10 11