Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

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

1  
is there anything else you can give us? – gbn Feb 15 '12 at 10:26
    
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 failer details.

share|improve this answer
    
Are you running both rebuild and reorganize in the same maintenance plan? – jgardner04 May 15 '12 at 20:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.