Running “Rebuild Index” maintenance plan with “Onl

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Running “Rebuild Index” maintenance plan with “Onl

Author

Topic

ajbharani
Starting Member

2 Posts

Posted - 2010-03-17 : 06:08:41

Hi

I am using Windows Server 2003 SP 2 and SQL Server 2005 Enterprise edition

I am creating a "Rebuild Index" job for a particular database and I am successfully able to run the job.

But when I try to enable the "Keep index online while rebuilding" option, the job does not execute successfully and throws out errors.

I have attached the screenshots. Any help would be app

http://img535.imageshack.us/gal.php?g=error1r.png

Thanks.

Kristen
Test

22859 Posts

Posted - 2010-03-17 : 07:03:37

ONLINE indexing is only supported in the Enterprise version (well ... and also the Developer version

).

You cannot use ONLINE if your index (or there is an index on the table which) is XML or SPATIAL; nor on Clustered indexes if the table contains LOB data types (image, text, ntext, varchar(max), nvarchar(max), varbinary(max), and XML); nor on Non-clustered indexes that explicitly index LOB data-type columns