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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-17 : 15:28:38
|
| My 160G database has doubled it's backup time from 3 hrs to 6 hrs. It is backed up across a backup LAN directly to a NAS device. Any ideas where to start looking to determine why the backup time has doubled?Thanks,Ray |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-17 : 15:51:04
|
| maybe you have more traffic on your LAN now. Maybe the NAS is busier than it used to be. Maybe you have transmission errors at the switch. Maybe your ethernet (hopefully gig ethernet) is having problems and is defective. maybe somebody stepped on the fiber and it is jacked up. Maybe your NAS is running degraded becuase you have lost a drive in your RAID 5. Maybe your SQL box RAID is running degraded becuase you have lost a drive in your RAIDset.check all of those and get back to us.-ec |
 |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-03-17 : 15:52:32
|
Well, if you haven't made any changes lately, which is where you should start, begin looking at your network (layer 1) and move up to the application layer.Check for things like wire speed (has it been renegotiated?), duplex settings (again - reneg?), layer 2 protocols that might be causing issues (i.e., spanning tree), etc. Make sure you run diags on the NIC.That should give you a start.  |
|
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-17 : 16:16:23
|
| I figured it out. I recently started checking the integrity of the backups which added another 3 hours to the backup job.Thanks!Ray |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-17 : 16:22:29
|
quote:
Originally posted by rb1373
I figured it out. I recently started checking the integrity of the backups which added another 3 hours to the backup job.
ahh, the obvious answer!You might want to look into using a product like sql litespeed to speed your backups up. It also compresses on the fly to make the resulting file smaller. I think imceda sells it now.i don't have any connection to this company btw, the product is pretty good though.-ec |
|
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-03-17 : 16:35:57
|
| I have thought about that. The one drawback is that this 160G database needs to be restored to another server after the backup and I have read on this site that files backed up with SQL Lightspeed take longer to restore. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-03-17 : 16:37:39
|
quote:
Originally posted by rb1373
I have thought about that. The one drawback is that this 160G database needs to be restored to another server after the backup and I have read on this site that files backed up with SQL Lightspeed take longer to restore.
that hasn't been my experience. I find the restores to be a little bit faster actually.-ec |
|
|
|
|
|
|
why did backup duration double?