Thanks a lot Gail for your valuable inputs. Since morning I was manually checking the pages and trying to backtrack the pages to tables manually. So far, I have found 2 tables with corrupted pages.

Interestingly, for one of the table, I got the below error -

Msg 8939, Level 16, State 28, Line 2

Table error: Object ID 1143334087, index ID 2, page (6:2932956). Test (m_slots[0].GetOffset () == PAGEHEADSIZE && m_type == IAM_PAGE) failed. Values are 0 and 96.

Msg 8939, Level 16, State 29, Line 2

Table error: Object ID 1143334087, index ID 2, page (6:2932956). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(IAMHEADER) + sizeof(DataRecHdr)) && m_type == IAM_PAGE) failed. Values are 0 and 94.

Msg 8939, Level 16, State 28, Line 2

Table error: Object ID 1143334087, index ID 2, page (6:2932956). Test (m_slots[0].GetOffset () == PAGEHEADSIZE && m_type == IAM_PAGE) failed. Values are 0 and 96.

Msg 8939, Level 16, State 29, Line 2

Table error: Object ID 1143334087, index ID 2, page (6:2932956). Test (Align(m_slots[-1].GetOffset ()) == Align(m_slots[0].GetOffset () + sizeof(IAMHEADER) + sizeof(DataRecHdr)) && m_type == IAM_PAGE) failed. Values are 0 and 94.

Msg 7965, Level 16, State 2, Line 2

Table error: Could not check object ID 1143334087, index ID 2 due to invalid allocation (IAM) page(s).

It seems to be that the IAM page is corrupted. Please correct me if im wrong. Then there will be a big dataloss for this database !!

I will try to run a full checkdb on this database post approval.

Please let me your view on this.

Regards,

Shovan.