jitendra.padhiyar (1/15/2013)

---

Ohh.. Is there any way to know how much data lost? Or how to find what table affected by that ?

jitendra.padhiyar (1/15/2013)

---

The were trying to perform below delete operation:

DELETE FROM PTPortalUser.PTJOBLOGS WHERE INSTANCEID < 614469

and got error message:

Msg 8908, Level 22, State 6, Line 1
Table error: Database ID 23, object ID 901578250, index ID 0. Chain linkage mismatch. (1:753306)->next = (1:753307), but (1:753307)->prev = (1:706408).

It seems its consistency error that Checkdb was not able to repair. Should I run checkdb again with All_ErrorMSGS ? to know whts going on ? OR any other way to cope with this error ? Indexid=0 seems cluster index issue..

Now, please run this so I can see if there are any remaining errors

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

jitendra.padhiyar (1/15/2013)

---

Just googled error message and found this issue occurs because the SHRINK operation cannot remove a page from the SYSFILES1 system table on the primary data file of the database. And we can fix it by applying latest service pack of SQL Server 2000!!

Jayanth_Kurup (1/15/2013)

---

@Gail , would it make sense now to add a clustered index or rebuild the clustered index ?

Are you able to access the table , can you create a copy of the table ?