debugMinor
SQL Server Maintenance Plan Fails to Rebuild the Indexes
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:
What would be the cause?
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.
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.