Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
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
add comment

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

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

1 Answer

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
add comment

Your Answer

 
discard

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