text, ntext, or image node - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

text, ntext, or image node

Author

Topic

dstpaul
Starting Member

10 Posts

Posted - 2011-02-24 : 12:21:11

We had a Raid5 drive go out but didn't realize the db had corruption for several weeks. It has now been too long to restore from backup. Should we buy a SQL DB Repair Tool - the following is the result of dbcc checkdb

Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3340726566912 owned by data record identified by RID = (1:6282:2) id = 466100701 and indid = 6.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 3340322668544 owned by data record identified by RID = (1:6638:1) id = 302272482 and indid = 1.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:2974986), slot 7, text ID 3340726566912 does not match its reference from page (1:6638), slot 1.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 2, text, ntext, or image node page (1:2974986), slot 7, text ID 3340726566912 is pointed to by page (1:6638), slot 1 and by page (1:6282), slot 2.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:5054961), slot 17, text ID 3340322668544 is not referenced.
DBCC results for 'PlayData'.
DBCC results for 'sysobjects'.
There are 14864 rows in 331 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 6456 rows in 980 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 5 consistency errors in table 'sysindexes' (object ID 2).
DBCC results for 'syscolumns'.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-02-24 : 22:17:28

Not repairable. It doesn't look too fatal, it's just the stats blobs of two indexes that are affected.

Can you query sysindexes and see which indexes are id = 466100701 and indid = 6 and id = 302272482 and indid = 1. Do a drop index on both, if it succeeds run checkDB on both.

--
Gail Shaw
SQL Server MVP

dstpaul
Starting Member

10 Posts

Posted - 2011-02-28 : 10:56:38

When is qry the 302272482 i get the following
Server: Msg 7105, Level 22, State 6, Line 1
Page (1:2974986), slot 7 for text, ntext, or image node does not exist.

Connection Broken
How do I drop index on them

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources