troubleshooting Question

Maintenance Plan failure

Avatar of manojbaba
manojbaba asked on
Microsoft SQL Server
2 Comments1 Solution544 ViewsLast Modified:
I have database in sqlserver 2008 Enterprise . some database are 150 Gb some are just 50 and some are 1 GB.
My maintenace job(consists of dbcc check db, index rebuild  ) has been failing after running 3 hours. before it will take 7/8 hours to complete and get succeed.


Note :

Since database log is getting full during the maintenance operation . I have scheduled t-log job every 30 min. but when I see the the job history it doesn't  ran on exact time like 12.30 , 1.00, 1.30 and so on. and one of database log file gets full at 2.50 even after taking frequent backup like every 30 min. and I saw the error msg  package failed at same time.

but last week I get error message   saying tempdb log is full at 3.30 and the package failed at 4.28.
but I don;t have error like having user database  t-log full last week.

How to solve the problem by keeping existing maintenance plan?




Thanks
ASKER CERTIFIED SOLUTION
David Todd
Senior Database Administrator

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros