HiveBrain v1.2.0
Get Started
← Back to all entries
debugMinor

SQL Server Maintenance Plan Fails to Rebuild the Indexes

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
failsthesqlindexesrebuildplanmaintenanceserver

Problem

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?

Solution

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.

Context

StackExchange Database Administrators Q#13094, answer score: 3

Revisions (0)

No revisions yet.