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 |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2004-06-09 : 23:54:16
|
| I'm currently backing up a 115 Gig database to disk, then the .bak file gets written to tape as part of the network backup.Problem: The last 2 days the backup time has doubled, and I can't see any reason why. What would make my backup time double ?? Also, I've been doing a VrfyBackup all along. Should I even bother with the verify if it's being written to disk ?? Is verify mainly used when writing directly to tape to make sure the tape is good ??SQL 2K, SP3Thanks for any help, Gabriel |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2004-06-10 : 02:33:21
|
| homebrew,Have you been running performance monitor by any chance? If not, consider setting this up, and logging your physical disk: average queue legnth, Disk Read bytes/sec (on the drive that has your DB), Disk Write Bytes/sec (on the drive where you write the backup).Personally I don't use VrfyBackup - never needed to. Maybe that is something others can comment on...CiaO*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
Backup time Doubled !