March 31, 2008 at 5:01 am
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.
March 31, 2008 at 5:48 am
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 recoverability
March 31, 2008 at 7:50 am
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 @sqlscribeApril 1, 2008 at 7:25 am
Are you running Standard Edition? If so, in the maintenance plan, make sure the option to keep the indexes online is not selected.
April 1, 2008 at 8:09 am
Thanks your replies.
I fixed the problem.
April 2, 2008 at 12:39 am
Could you tell us, where the problem was?
April 2, 2008 at 1:09 am
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