Reorganize Index Task failed but no error messages
-
Dear,
I am using SQL 2005 9.0.2047 and created a Maintenance Plan to do Reorganize Index Task on my databases.
Some of them succeed, but most of them failed.
But if I clicked "View history", no error details displayed but just :
Message
Executed as user: CTERTH\administrator. The package execution failed. The step failed.
How can I fix the error ?
But when I chose "Rebuild Index Task", all databases succeeded.
Why ? Please tell me.
-
In the properties of the maintenance plan you can set the plan to log to a text file. It will write far more detailed info than went into the job history.
Might give you a clue why the reorg is failing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
You might also consider applying the latest cumulative update (http://support.microsoft.com/kb/937137). There are a number of fixes available for maintenance plan tasks.
Good luck
Tommy
Follow @sqlscribe -
Are you running Standard Edition? If so, in the maintenance plan, make sure the option to keep the indexes online is not selected.
-
Thanks your replies.
I fixed the problem.
-
Could you tell us, where the problem was?
-
The "Use page locks when accessing the index" option.
If unchecked it, the index re-ogranization would fail.
But I don't understand why by default :
(1)This option is checked when we create a primary key
(2)but by default, it is unchecked when we create an index other than primary key.
Is it normal, or the service pack problem ?
My SQL 2005 is sp1 : 9.0.2047.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply