Rebuild Index Task fails
Posted on 2007-07-26
I have a rebuild index task in a maintenance plan that keeps failing with the following error:
Error: 0xC002F210 at Rebuild Index Task, Execute SQL Task: Executing the query "ALTER INDEX [apinvdtl#_#progress_recid] ON [dbo].[apinvdtl] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )
" failed with the following error: "The transaction log for database 'MfgSys80' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases
The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Rebuild Index Task
SSIS package "SQL1Backup.dtsx" finished: Success.
I've checked the log_reuse_wait_desc column in sys.databases and it's set to NOTHING. I can't seem to find a good explanation of what NOTHING means in MSDN. I manually truncated my log file yesterday, so I'm not sure how it could be out of space already.
Any insights would be greatly appreciated.