When I run a maintenance plan to reorganize and rebuild tables indexes, it fails. Below the last two rows that displays the fail:

 Source: Reorganize Index      
 Executing query "ALTER INDEX [PK_xxTableName] O...".: 15% com...  
 The package execution fa...  
 The step failed.

What would be the cause?

migrated from stackoverflow.com Feb 15 '12 at 12:45

This question came from our site for professional and enthusiast programmers.

  • 1
    log the maintenance plan to file, might give more details here than "..." – cairnz Feb 15 '12 at 12:42
  • 3
    Could be lots of stuff. Corrupt index? Index that got dropped after the job started? Hard to know based on what you're provided. – Grant Fritchey Feb 15 '12 at 14:14

Well, I have found the answer to this.

I removed the tick from "Compact Large Objects" option and just included the re-organize and re-build indexes tasks and it succeeded!!! Also I will log to text file for future failure details.

  • 1
    Are you running both rebuild and reorganize in the same maintenance plan? – jgardner04 May 15 '12 at 20:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy