Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I recently recovered a database from a hard-drive failure using DBCC CHECKDB WITH REPAIR ALOW DATA LOSS.

Now I can select records from a table-valued function to retrieve sales records, but using a GROUP BY on the same data causes an "internal inconsistency" error.

Running DBCC CHECKDB returns zero inconsistency errors.

I have run everything I know to detect any torn pages, but have found none.

How do I find the torn page or force a rebuild?

share|improve this question

migrated from Aug 31 '11 at 16:43

This question came from our site for system and network administrators.

Basically, you have to restore. Do you have a backup?

While this is restoring, read "Misconceptions around database repair" and the rest of Paul Randal's site.

Harsh, but true.

share|improve this answer
This database has been live for a while since the last backup. The last full backup was made while (presumably) the previous disk was already failing, so won't the backup be suspect too? In other words, won't it be like restoring a backup made in the present state? – pate Aug 31 '11 at 22:14

You should be able to look at the page itself using DBCC PAGE and see if the page is still corrupt and what's going on. What version of SQL Server was the backup created with?

share|improve this answer
SQL Server 2008. Not sure of the service pack at the time, if that matters? – pate Sep 1 '11 at 10:21
The service pack version shouldn't matter. Can you post the full error you get when you are running the query with the group by? – mrdenny Sep 1 '11 at 22:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.