currupted index

  • DBCC check db job for all user databases is failing with below error message. Looks like index is currupted. How to resolve this?

    sql server 2000

    Executed as user: XYZ\sqlservice. ...ER' with Windows Authentication Logged on to SQL Server 'ServerName' Starting maintenance plan 'LITESPEED - DBCC INTEGRITY CHECKS User Databases - WEEKLY SAT 9_15 PM [Subplan 1]' on 1/12/2013 9:15:00 PM [1] Enum database list... Selected database list: DBName BrowserMessageDB_Prod CommonSecurity_V2 CT DataExchange_Prod2 DocumentControl SecurityDB TimeAccounting WebLogger WebTracking [1] Execution Time: 0 hrs, 0 mins, 0 secs. [2] Database "DBName": Check Data and Index Linkage... Msg 8952, Level 16, State 1, Line 1179650: Table error: Database 'DBName', index 'SyncServerState.PK_SyncServerState' (ID 946102411) (index ID 2). Extra or invalid key for the keys: Msg 8956, Level 16, State 1, Line 1179650: Index row (1:359:3) with values (Id = 4 and ServerConfigId = 0 and Type = 'DevMgmtServerConfigHistoryId') points to the data row identified by (). Msg 8952, Level 16, State 1, Line 1179650: Table e... The step failed.

  • Index Id 2 should relate to a non-clustered index, simply drop and recreate the index and you should resolve the issue. After that run a DBCC CHECKTABLE('YouTable') WITH ALL_ERRORMSGS , NO_INFOMSGS to see if everything's okay.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply