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 Checktable error.

Author  Topic 

Laxminarayana
Starting Member

2 Posts

Posted - 2010-05-16 : 10:04:05
Hi,

After running DBCC checktable with alow data loss, i got below messages.

Repair: Deleted text column, text ID 6434390016, for object ID 117575457 on page (1:14314522), slot 22.
Repair: Deleted text column, text ID 6434652160, for object ID 117575457 on page (1:14314522), slot 26.
Repair: Deleted text column, text ID 6435438592, for object ID 117575457 on page (1:14314522), slot 38.
Repair: Deleted text column, text ID 6436028416, for object ID 117575457 on page (1:14314522), slot 46.
Repair: Deleted text column, text ID 6436093952, for object ID 117575457 on page (1:14314522), slot 47.
Repair: Deleted text column, text ID 6436159488, for object ID 117575457 on page (1:14314522), slot 48.
Repair: Deleted text column, text ID 6436225024, for object ID 117575457 on page (1:14314522), slot 49.
Repair: Deleted text column, text ID 6438977536, for object ID 117575457 on page (1:14314522), slot 91.
Repair: Deleted text column, text ID 6439043072, for object ID 117575457 on page (1:14314522), slot 92.
Repair: Deleted text column, text ID 6439436288, for object ID 117575457 on page (1:14314522), slot 98.
Repair: Deleted text column, text ID 6439698432, for object ID 117575457 on page (1:14314522), slot 102.
Repair: Deleted text column, text ID 6439763968, for object ID 117575457 on page (1:14314522), slot 103.
Repair: Deleted text column, text ID 6439829504, for object ID 117575457 on page (1:14314522), slot 104.
Repair: Deleted text column, text ID 6439895040, for object ID 117575457 on page (1:14314522), slot 105.
Repair: Deleted text column, text ID 6440288256, for object ID 117575457 on page (1:14314522), slot 111.

can any one pls explain in detail?

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-16 : 10:21:10
You saked SQL to fix the table and discard any data that it needed to in the process. It discarded a whole bunch of text records, that's data in text, ntext or image data types (this looks like SQL 2000). Can't say much (anything really) more about what exactly it dropped.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -