DBCC CheckDb Error Message

Question

DBCC CheckDb Error Message

Testsubjec

SSC Veteran

Points: 269
More actions
February 12, 2014 at 2:47 am

#303966

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.

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

enriquemallon Ten Centuries Points: 1239 More actions · Answer 2

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.