subject: Resolving table Error: Object Id O_id....p_id4, Slot S_id Expects For This Page [print this page] Data pages in metadata structure of MS SQL Server database can either be structured in a B-tree or Heap tree format. In a B-tree structure, the pages are connected to each other at a single level point, in a doubly-linked list. Each parent page in a B-tree contains the records of all its children, including their Page Ids and keys. Corruption in metadata structure primarily results in loss or corruption of values stored in parent page. Few main causes for metadata structure damage are improper SQL Server shutdown, human errors, and virus infection. The data stored in the SQL database becomes inaccessible after the corruption in metadata structure. In such cases, the records can be accessed easily by restoring them from an updated backup. However if in case, no backup is available, then you will need to repair the corrupt database using advanced third-party SQL Repair application.
Picture a situation, where the underneath error message pops up when you attempt to access the records stored in SQL Server database table:
Table error: Object ID O_ID, index ID I_ID. The previous link P_ID1 on page P_ID2 does not match the previous pageP_ID3 that the parent P_ID4, slot S_ID expects for this page.
The above table error results in inaccessibility of records stored in the table. Moreover, the error message pops up every time you try to view the records stored in these tables.
Cause
The above error message is primarily caused when there is some kind of metadata structure damage of SQL database. In the above case, the page P_ID2 is the left sibling of P_ID1 and points back to it. However, P_ID4 (P_ID2's parent page), thinks P_ID3 is a P_ID2's left sibling.
Resolution
DBCC CHECKDB (with repair command) enables you to resolve the above error message and to access the table data. However, if the command fails to repair the database component, then you will need to use advanced SQL Database Repair tool to repair the database. A third-party sql repair utility ensures complete repair of corrupt SQL database components by using powerful scanning methods.
SQL Recovery is a high quality product that instantly repairs corrupt database components. The repaired components can either be saved on new or default location. The ms sql repair software is compatible with SQL Server 2008, 2005, and 2000 and supports Windows 7, Vista, XP, 2003, 2000 and NT. It is read-only in nature.
