dbcc checkdb result - 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

dbcc checkdb result

Author

Topic

sasan.kh
Starting Member

23 Posts

Posted - 2009-04-14 : 10:45:44

Hi dear all

I have a sql server 2000 sp4 database working in a company... I usually get consistency errors all of which are corrected by rebuilding indexes but recently i get the following result when executing "dbcc checkdb with no_infomsgs, all_errormsgs":

Server: Msg 8960, Level 16, State 1, Line 1
Table error: Page (1:16269), slot 66, column 2 is not a valid complex column.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 1435079. The text, ntext, or image node at page (1:97232), slot 85, text ID 55999922176 is not referenced.
CHECKDB found 0 allocation errors and 1 consistency errors not associated with any single object.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'spJavab_Az' (object ID 1435079).
CHECKDB found 0 allocation errors and 2 consistency errors in database 'dbSina'.
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (dbSina ).

can any one kindly help me, I dont know what does it mean and what to do

best regards
sasan

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-14 : 13:28:13

Moving this to the data corruption forum.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-04-14 : 13:29:32

I'm surprised that you get data corruption a lot and that the root cause has not been corrected. This is not normal.

It looks like you are going to lose data. Do you have backups?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-04-15 : 03:23:16

I'm not sure of the meaning of the first error, I'm sure Paul will happily explain when he sees this.

The second error indicates that there's data stored out of page (for TEXT, NTEXT or IMAGE) but that the row that the data belongs to isn't there. This can be the result of repairing earlier corruptions. While the repair recommendation is 'allow_data_loss', the data that this error refers to is already lost.

Corruption, especially repeated corruptions is often the result of problems with the IO subsystem. I would suggest that you carefully check the IO subsystem for any problems.

--
Gail Shaw
SQL Server MVP

sasan.kh
Starting Member

23 Posts

Posted - 2009-04-16 : 09:29:20

Thanx all,
I am trying to check any hardware problems but it seems that everything is working properly

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2009-04-27 : 06:29:28

The first error is saying that a link to an off-row text value is corrupt. The second error is saying that some off-row text isn't referenced - this is because of the first error - CHECKDB couldn't process the 'missing' reference.

Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)
SQL Server MVP, Microsoft Regional Director, Contributing Editor of TechNet Magazine
Author of SQL 2005 DBCC CHECKDB/repair code
Author & Instructor of Microsoft Certified Master - Database course

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-04-27 : 11:49:12

Thanks Paul.

Under what other circumstances can you get that error? - column x is not a valid complex column.

--
Gail Shaw
SQL Server MVP

paulrandal
Yak with Vast SQL Skills

899 Posts

Posted - 2009-04-27 : 15:56:55

When the column value gets corrupted :-)

Paul S. Randal, Managing Director, SQLskills.com (www.SQLskills.com/blogs/paul)
SQL Server MVP, Microsoft Regional Director, Contributing Editor of TechNet Magazine
Author of SQL 2005 DBCC CHECKDB/repair code
Author & Instructor of Microsoft Certified Master - Database course

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-04-27 : 17:11:54

So any damage to any column can give that? It's not unique to off-row pointers and not specific to certain data types?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources