Sql Server 2005 SP2
I have a maintenance plan to perform CHECKDB, Reindex, Backup, Cleanup tasks in that order. Lately, its been running very very long. For more than 2 days. Initially it was because of a bunch of reasons i.e. disk ran out of space, TRN and BAK jobs running on
top of each other, etc. But now, I created a new plan with just backup. Even that runs forever. Just simple backup, nothing else (small database).
Now, if I create a job with T-Sql command and run it, it runs fast in under a second. But if I create
a Maintenance Plan on the same database it takes forever. How do I troubleshoot this? I do not get any errors because, I stop the job after running for a few hours.
View Complete Post