April 9, 2003 at 1:09 pm
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.
April 9, 2003 at 1:22 pm
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply