Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Page missing in a Clustered Index on a table Expand / Collapse
Author
Message
Posted Monday, July 9, 2012 12:52 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 5,358, Visits: 8,914
Running DBCC Checkdb on a database yielded the following:
DBCC CHECKDB(N'MyDB') WITH NO_INFOMSGS

Table error: Object ID 2057110419, index ID 1, partition ID 72057597444161536, alloc unit ID 72057597501833216 (type In-row data). Page (1:7823149) is missing a reference from previous page (1:7823150). Possible chain linkage problem.
Table error: Object ID 2057110419, index ID 1, partition ID 72057597444161536, alloc unit ID 72057597501833216 (type In-row data). Page (1:7823150) was not seen in the scan although its parent (1:5720869) and previous (1:7823151) refer to it. Check any previous errors.
CHECKDB found 0 allocation errors and 2 consistency errors in table 'MyTable' (object ID 2057110419).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'MyDB'.
repair_rebuild is the minimum repair level for the errors found by DBCC CHECKDB (MyDB).


(Names of DB and table changed...)

Index 1 is the clustered index on this table (and also it's PK), and there are no other indexes on this table. One of the columns in the PK (the last column) is an identity column. Client says that data appears to be only inserted into the table - and that they don't have a maintenance window. The table has ~ 200 million records.

I'm thinking that I should:
Restore the database to a parallel database, ensure that it is a clean DB with DBCC CHECKDB, and then check the gaps on the identity column.
Run the repair_rebuild on this database, and check for gaps on the identity column.
Compare the gaps, and we'll know which ones need replaced.

Gail, Paul, and other corruption gurus... do you see anything else that I should look into or have any other suggestions for how to handle this?

Thanks in advance for taking time out of your busy day to look / respond to this.


Wayne
Microsoft Certified Master: SQL Server 2008
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links: For better assistance in answering your questions, How to ask a question, Performance Problems, Common date/time routines,
CROSS-TABS and PIVOT tables Part 1 & Part 2, Using APPLY Part 1 & Part 2, Splitting Delimited Strings
Post #1327077
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse