March 11, 2003 at 9:41 am
My backups are running 5-6 hours on SQL2000. I'm sure they only used to take 1 hour or so. On another server, backing up the same type of database (both about 50 gig), the backup only takes 45 min - 1 hour. What can I look at to see why it's taking so long ?
March 11, 2003 at 11:20 am
Disk io and cpu time to start - is the server maxed out when you backup? Could also be that you have more data, that it's more fragmented (rebuilding indexes regularly?), or that you have jobs running/users accessing more than used to during the backup period.
Andy
March 14, 2003 at 10:36 am
If you have multiple processors you can speed up your backup by adding more backup files.
March 15, 2003 at 9:09 am
I am also having problems that backups running longer on one of my server (SQL 6.5), whch has 2 processors. Could you please let me know how to add more backup files?
To speed up the process, I have split the job and created another job to have the indexes rebuilt.
.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply