Tell me more ×
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.
up vote 2 down vote favorite

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

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

1 Answer

up vote 1 down vote

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.