Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!)


Corrupt Database running dbcc checkdb, missing sys.indexes (urgent help needed!)

Author
Message
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47453 Visits: 44405
Holger, does this query return anything? If so, try a drop statistics with the name returned and see if that fixes the problem. Absolutely no promises.

select object_name(object_id), name, stats_id from sys.stats where object_id = 1379588053 and stats_id = 3




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


Paul Randal
Paul Randal
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2179 Visits: 1714
Hey Gail - I keep forgetting that trick you used last time too - cool if that works.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Holger Degroot
Holger Degroot
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 21
Hi Gail,

yes, hopefully DBCC CHECKDB works now.
The Statement delivers one entry: table and the field-/value/entry
DROP STATISTICS gwdatastruct._WA_Sys_DataFormat_523AD7D5 works also
and now checking the Database again.
Will inform you in about 15 minutes.
Thanks for now.

Kind regards
Holger Degroot
Holger Degroot
Holger Degroot
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 21
hi Gail,

this worked out. Thankx a LOT!!!!

now the followin errors appear:
I will treat them the same way and report later on.

DBCC-Ergebnis für 'SysSrvAccess'.
Es sind 2725 Zeilen auf 49 Seiten für das "SysSrvAccess"-Objekt vorhanden.
DBCC-Ergebnis für 'GWSYSMessages'.
Meldung 8978, Ebene 16, Status 1, Zeile 1
Tabellenfehler: Objekt-ID 1870017793, Index-ID 4, Partitions-ID 72057594130071552, Zuordnungseinheits-ID 72057594165723136 (In-row data-Typ). Für Seite (1:102) fehlt ein Verweis der Vorgängerseite (1:215041). Möglicherweise liegt ein Kettenverknüpfungsproblem vor.
Meldung 8928, Ebene 16, Status 1, Zeile 1
Objekt-ID 1870017793, Index-ID 4, Partitions-ID 72057594130071552, Zuordnungseinheits-ID 72057594165723136 (In-row data-Typ): Seite (1:215041) konnte nicht verarbeitet werden. Einzelheiten finden Sie in anderen Fehlermeldungen.
Meldung 8976, Ebene 16, Status 1, Zeile 1
Tabellenfehler: Objekt-ID 1870017793, Index-ID 4, Partitions-ID 72057594130071552, Zuordnungseinheits-ID 72057594165723136 (In-row data-Typ). Seite (1:215041) wurde im Scan nicht betrachtet, obwohl das übergeordnete Element (1:427259) und der Vorgänger (1:175) darauf verweisen. Überprüfen Sie ggf. alle vorherigen Fehler.
Meldung 8944, Ebene 16, Status 16, Zeile 1
Tabellenfehler: Objekt-ID 1870017793, Index-ID 4, Partitions-ID 72057594130071552, Zuordnungseinheits-ID 72057594165723136 (In-row data-Typ), Seite (1:215041), Zeile 46. Fehler bei Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)). Die Werte sind 58387 und 35.
Meldung 8944, Ebene 16, Status 16, Zeile 1
Tabellenfehler: Objekt-ID 1870017793, Index-ID 4, Partitions-ID 72057594130071552, Zuordnungseinheits-ID 72057594165723136 (In-row data-Typ), Seite (1:215041), Zeile 46. Fehler bei Test (VarColOffsets + (int)(sizeof (class VarColOffset) * nVarCols) <= (nextRec - pRec)). Die Werte sind 58387 und 35.
Es sind 36967 Zeilen auf 2454 Seiten für das "GWSYSMessages"-Objekt vorhanden.
Von CHECKDB wurden 0 Zuordnungsfehler und 5 Konsistenzfehler in der 'GWSYSMessages'-Tabelle (Objekt-ID 1870017793) gefunden.
DBCC-Ergebnis für 'DOCUMENTTEMPLORel'.
Es sind 165 Zeilen auf 6 Seiten für das "DOCUMENTTEMPLORel"-Objekt vorhanden.

Thanks for the moment.

Holger Degroot
:-)
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47453 Visits: 44405
Holger Degroot (6/2/2009)
hi Gail,

this worked out. Thankx a LOT!!!!


Excellent. I'm glad to hear that.

I don't understand the errors (sorry, don't speak or read German) so I can't advice you on them.


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


Paul Randal
Paul Randal
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2179 Visits: 1714
These are all record corruptions in nonclustered index ID 4. My guess is your IO subsystem is causing corruption, which was what corrupted the system table too.

You should be able to offline rebuild the index to fix this, otherwise you're looking at drop/create or repair to rebuild it. If these are the only corruptions, there's no point restoring from your backups the nonclustered index is redundant data anyway.

You also need to find out what's causing these corruptions so you can fix it so they don't happen again to something more critical that can't be repaired.

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47453 Visits: 44405
Paul, could the previous error have been hiding these, or do you think they're new corruptions?


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


Paul Randal
Paul Randal
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2179 Visits: 1714
If that was the only error in the original CHECKDB output, then no, they weren't masked - as the catalog checks that produce that error are run after the checks that produced the second set of errors.

Holger - was the 8992 error the *only* error in the first set of CHECKDB results? if so, these are new corruptions.

Having it all in German isn't helping things either (no fault of yours Holger!).

Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Holger Degroot
Holger Degroot
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 21
Hi Paul,
yes it was the first and only error.

I will try to use the English MMS console to post English messages (sorry for that)

i will start to rebuild and repair the other errors and then give a feedback.


holger degroot
GilaMonster
GilaMonster
SSC-Forever
SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)SSC-Forever (47K reputation)

Group: General Forum Members
Points: 47453 Visits: 44405
Holger Degroot (6/2/2009)
Hi Paul,
yes it was the first and only error.


If that's the case, I would suggest two things before you try a fix.
1) Evaluate your IO subsystem - check for errors in event logs or RAID error logs
2) Get that database onto different disks or a different IO system completely.

If you've got new corruptions appearing then there's a serious problem here.


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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search