asked
Rebuild Index Problem
Can you please help shed some light on rebuilding an index and severe error and disconnect? Why and any work around for it? THANK YOU. ALTER INDEX [IX_ATTR_ENTITY_ID] ON [ISII].[dbo].[ATTRIBUTE] REBUILD WITH (SORT_IN_TEMPDB = OFF, ONLINE = ON) Getting the following error:- The statement has been terminated. The statement has been terminated. Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. Msg 0, Level 20, State 0, Line 0 A severe error occurred on the current command. The results, if any, should be discarded. IndexType: NonClustered, LOB: No, AllowPageLocks: Yes, PageCount: 1405756, Fragmentation: 70.2575
Run a DBCC CHECKDB and see if there are inconsistencies and/or other errors in the database.
I agree with Margnus, for check corruption you can also run DBCC CHECKTABLE for table on which you are trying to rebuild index also you can try to drop and recreate index.
I agree with Magnus, run DBCC CHECKDB. You can also try to use CREATE INDEX and specify the option DROP_EXISTING=ON if it's not the clustered index. If you have corruption in a regular index (not the clustered index), you will get rid of the corruption when the index is dropped and recreated without any dataloss. On the other hand if it's the clustered index, you'll probably get dataloss. Anyway, you should use a frequent routine to check for corruption in your database to prevent any dataloss.
You could also try running it with ONLINE = OFF.
