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 acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.