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
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.