Hi Experts, Today one of my database took more than expected time for backup i have no idea why it took much time, can any one help me in this if any one gone through this condition/situation. your suggections could help me out in future. The size of the backup is 30GB and the server is SQL Server 2005 enterprise edition on windows 2003 enterprise edition. Thank you in advance
Hi KSR, As Luis mentioned, did you observed any maintenance activity while backup job was running ? I would suggest check job history and SQL Logs of said time frame to get more details.
I do forecast that another un-scheduled backup job is running side by side with your scheduled backup jobs yielding to clashes ( Heavy locks ) between both jobs ending up with delay for the 2nd one .. May you check on this assumption and let me kwon your feedback
Contention issue like Shehap described is likely what caused the delay. Another possibility, although it is less likely, is hard disk (or raid) issue. When it happened, it delayed our backup 10 folds. Check the windows event log and make sure there is no disk issue.
Hi All, Thank you for your valuable time and for your suggestions. I was doing the backup from a cmd window and it is to a local drive and I usually do the regular backup job's to SAN drive from my maintenance plan. I have no idea what might be the prob. No there was no job running other than this one. Thank you All in Advance.
