• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1361
  • Last Modified:

Rebuild Index Task fails

Hello,
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.
Thanks
Chad
0
ChadMarsh
Asked:
ChadMarsh
1 Solution
 
patriktCommented:
Because Reindex operation is producing large amount of logged operations you can get full log by reindex itself.
Add more space to your logfile or add another logfile.
0
 
ChadMarshAuthor Commented:
Thanks. That seemed to do the trick
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now