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.
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?