Consistency errors in table 'sys.sysobjvalues' (object ID 60)

• kki 39631

  SSC Veteran

  Points: 270

  More actions

  January 20, 2015 at 2:12 am

  #314713

  Good day All,

  I would appreciate your expert recommendations on getting this issue resolved.

  I am a relative newby to SQL to please bear with me.

  I have run a DBCC CHECKDB (mydb) with no_infomsgs and get the following result:

  Msg 8935, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The previous link (1:51553) on page (1:45424) does not match the previous page (1:94976) that the parent (1:97186), slot 255 expects for this page.

  Msg 8934, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The high key value on page (1:94976) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:51553).

  Msg 8977, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Parent node for page (1:51553) was not encountered.

  CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.sysobjvalues' (object ID 60).

  I then tried running the DBCC to repair allow data loss and get the following:

  Msg 1505, Level 16, State 1, Line 1

  The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'sys.sysobjvalues' and the index name 'clst'. The duplicate key value is (60, 2101074721, 18, 0).

  DBCC CheckDB(mydb) WITH NO_INFOMSGS, ALL_ERRORMSGS results:

  Msg 8935, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The previous link (1:51553) on page (1:45424) does not match the previous page (1:94976) that the parent (1:97186), slot 284 expects for this page.

  Msg 8934, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). The high key value on page (1:94976) (level 0) is not less than the low key value in the parent (0:1), slot 0 of the next page (1:51553).

  Msg 8977, Level 16, State 1, Line 1

  Table error: Object ID 60, index ID 1, partition ID 281474980642816, alloc unit ID 281474980642816 (type In-row data). Parent node for page (1:51553) was not encountered.

  CHECKDB found 0 allocation errors and 3 consistency errors in table 'sys.sysobjvalues' (object ID 60).

  CHECKDB found 0 allocation errors and 3 consistency errors in database 'mydb'.

  repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (mydb).

  How do I go about resolving the duplicate error on the sys.sysobjvalues?

  Regards,

• January 20, 2015 at 11:25 pm

  This was removed by the editor as SPAM

• kki 39631

  SSC Veteran

  Points: 270

  More actions

  January 20, 2015 at 11:45 pm

  #1771685

  Thank you for the reply.

  Unfortunately, there are no other backups available.

  The database recovery mode is set to simple although having a relatively large log file.

  The client would like to use this database purely for reading data from within the application. This is also a requirement from the local tax authorities for reporting.

  All other databases using the application has been upgraded to a later version of the application, and is not backward compatible.

• August 22, 2021 at 7:20 pm

  This was removed by the editor as SPAM