SharePoint Blog: SharePoint 2010 Beta – No longer possible to keep indexes on-line while rebuilding them

SharePoint 2010 Beta – No longer possible to keep indexes on-line while rebuilding them

Just a quick note to make sure that anyone typing this error message into a search engine will find this post.

Due to a change in the SharePoint 2010 AllDocVersions table it is no longer possible to rebuild indexes as part of a SQL 2008 maintenance plan and keep the indexes on-line at the same time.

The reason behind this is that the MetaInfo field is no longer of type Image. It is now of type tCompressedBinary:varbinary(MAX).

If you get the error listed below then make sure you open the Rebuild Index Task in your SQL Maintenance plan and disable the ‘Keep index online while reindexing’ option.

http://www.muhimbi.com/blog/2010/02/sharepoint-2010-beta-no-longer-possible.html