subject: Tips To Resolve object Id O_id, Forwarding Row Page P_id1... Error Message [print this page] The data saved in MS SQL Server table can either be organized in clustered or non-clustered (heap) structure. While the clustered tables have a particular clustered index, the data rows (contain table data) in non-clustered structure are not stored in any particular value. To connect these data rows, each forward row always points to the forwarding row. However, there might be situations where you encounter an error message stating that the forward rows are not pointing to the forwarding rows. This primarily occurs due to corruption in metadata structure, which further results in inaccessibility of database records. In such situations, the data stored in the database can be accessed by restoring it from an updated database backup. However, if in case, the database backup is not available, then you will need to use advanced SQL Database Repair application.
Picture a scenario, where you receive the underneath error message when you try to mount your SQL database:
Object ID O_ID, forwarding row page P_ID1, slot S_ID1 points to page P_ID2, slot S_ID2. Did not encounter forwarded row. Possible allocation error.
After the above error message appears, all the database records become inaccessible.
Cause
The above error message primarily occurs when the forwarding row in heap points to a damaged or non-existing forwarded row.
Note: This happens when there is corruption in metadata structure due to logical or physical factors.
Resolution
The resolution of the above error message can be achieved by following below two measures:
Change the physically corrupted computer system object with a new object.
Run DBCC CHECKDB, with appropriate repair clause.
While the first measure ensures complete resolution from all physical damage issues, the second measure resolves all logical issues. However, the second resolution does not proves successful in all cases. To resolve the remaining cases, you will need to use advanced SQL Database Repair application. A third-party sql repair tool employs high-end scanning algorithms to comprehensively scan and repair corrupt SQL databases. These tools are easy-to-understand and provide risk-free database repair.
SQL Recovery instantly repair corrupt databases created in SQL Server 2008, 2005, and 2000, and restores them on default or user-specified location. Compatible with Windows 7, Vista, XP, 2003, 2000 and NT operating systems, the ms sql repair software repairs almost all database components, such as, tables, views, rules, and more.
