June 9, 2004 at 9:54 pm
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, SP3
Thanks for any help,
Gabriel
June 10, 2004 at 1:49 am
Has there been a sudden reduction in disk-space on your server?
What size are your log files? Are they expanding at some point during the backup?
We had a situation where a maintenance plan corrupted and stopped deleting old backups. Disk space went down to 24Mb and the entire server slowed to a crawl.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply