database catalog corruption

• cneuhold

  Hall of Fame

  Points: 3375

  More actions

  April 9, 2003 at 1:09 pm

  #64665

  hi everyone!

  just ran into the following problem (win2k server, sql2k sp2). "dbcc checkcatalog" returns:

  Server: Msg 823, Level 24, State 2, Line 1

  I/O error 23(Data error (cyclic redundancy check).) detected during read at offset 0x00000000262000 in file 'X:\dbname_Data.MDF'.

  this is consistent with controller error messages in the event log ("bad cluster"). interesting thing: chkdsk does not find any bad clusters

  i issued "dbcc checkdb('dbname', repair_rebuild)" which returns:

  Server: Msg 7995, Level 16, State 1, Line 1

  Database 'aiba' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further CHECKDB processing.

  so now i'm stuck. i admit that above message really sounds logical (catalog damaged -> check not possible), but how can i repair the catalog?

  thanks for any help in advance,

  chris.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  April 9, 2003 at 1:22 pm

  #453620

  You may try to run DBCC CHECKDB with 'REPAIR_ALLOW_DATA_LOSS' option to see whether you can fix it. But as system objects seems damaged, you better have full database backup ready for the restoration.