January 15, 2011 at 1:16 am
Hi,
I'm running the Rebuild Index Maintenance task for the Share Point content database and I have selected the options Sort in tempdb and rebuild Index online while creating the Maintenance plan. But the Index rebuild task failed with the below error:
Failed:(-1073548784) Executing the query "ALTER INDEX [AllDocs_PK] ON [dbo].[AllDocs] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = ON, ONLINE = ON )
" failed with the following error: "Online index operation cannot be performed for index 'AllDocs_PK' because the index contains column 'BuildDependencySet' of data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml. For non-clustered index the column could be an include column of the index, for clustered index it could be any column of the table. In case of drop_existing the column could be part of new or old index. The operation must be performed offline.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Please advice
January 15, 2011 at 1:27 am
There are restrictions for online rebuild operations.
indexes that have columns of data types data type text, ntext, image, varchar(max), nvarchar(max), varbinary(max) or xml cannot be rebuild online.
I think your index AllDocs_PK is the clustering index for that table and that table contains columns of one of these data types.
Keep in mind a clustering index actually contains the tables data pages at leaf level !
bol ref: http://msdn.microsoft.com/en-us/library/ms177443%28v=SQL.90%29.aspx
The only solution is to rebuild them offline.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply