开发者

Database Inconsistency Error SQL Server 2000

After running DBCC checktable with allow 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.**

From above how can I know which data is deleted or What is id number of that particular row...

So that I can get back to the row

Can any one please tell me this......Tha开发者_C百科nx


It can't be done, I'm afraid. DBCC checktable is really only there to check and assert the integrity of all the pages and structures that make up the table. It doesn't record what the associated data might be.

Check out the reading on the following links

http://msdn.microsoft.com/en-us/library/ms174338.aspx

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=144677

http://www.sqlhacks.com/FAQs/DBCC-REPAIR_ALLOW_DATA_LOSS

Did you back up before doing this? If so your best options would be referring to the backup.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜