DBCC CheckDb Error Message

  • Hi,

    I'm trying to recover a database which unfortunately we don't have any backups of.

    I have ran the following command "DBCC CHECKDB ('CustomerAccounts') WITH TABLOCK, ALL_ERRORMSGS, NO_INFOMSGS;"

    And I'm getting this error:

    Msg 8921, Level 16, State 1, Line 1

    Check terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent. Check previous errors.

    Msg 8968, Level 16, State 1, Line 1

    Table error: SinglePage page (0:249856) (object ID 485576768, index ID 2, partition ID 72057594097827840, alloc unit ID 72057594105167872 (type In-row data)) is out of the range of this database.

    CHECKDB found 1 allocation errors and 0 consistency errors in table 'CTL_DBCONFIG' (object ID 485576768).

    CHECKDB found 1 allocation errors and 0 consistency errors in database 'CustomerAccounts'.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x369dfd27; actual: 0xd5f0c896). It occurred during a read of page (1:1599) in database ID 7 at offset 0x00000000c7e000 in file 'D:\Act Database Files\CustomerAccounts.ADF'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

    Please could someone advise.

  • You are not going to like the answer...

    That's not repairable. Script all objects (and hope that none fail), export all data (and some may fail), recreate the database.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • hi

    To solve this issue you must have backup but unfortunately you are trapped in condition when backup is unavailable. So you may try any third party tool which is reliable and robust.

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

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