By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,473 Members | 3,505 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,473 IT Pros & Developers. It's quick & easy.

Backup time increasing

P: 36

I've been noticing that while taking a snapshot backup in MSSQL 2000 the time taken to backup the database completes in around 10-12 minutes for a approx. 16GB DB but still time notified in comepleting the job in job history is around 40 minutes.

This is happening not daily but once or, twice a week while normal reported time taken to complete the job is around 18-20 minutes.

I reckon that could be due to excessive time taken while verifying the backup.

What I want to know is whether I am right in my opinion of the cause or, there could be something else also lurking & escaping from my attention?

What else could be possible reasons & ways to check & resolve them?

How can I reduce the overall backup time including verifying backup?

Would appreciate if somebody could help me identify the problem.

Ankit Mathur[/color]
Oct 29 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.