Thursday, January 28, 2010

Fixing “Forwarded row referenced...” Error Message

Whenever MS SQL Server encounters a problem while mounting your database, it displays an error message. Each error message displayed contains few important details like, message number, severity level of the problem, the problem itself, and sometimes the solution. The main reason for the occurrence of the error message is corruption is SQL Server database. In such cases of SQL database unmountability, the database records become inaccessible. The fundamental way used by most of the database administrators to access the records is by restoring the database from an updated backup. But, if in case these administrators forget to create a backup file or backup itself gets corrupted, then they will need to repair the database. To do so, they need an efficient SQL Recovery application.

Consider a practical case, where the underneath error message pops up while you attempt to mount the database:

“Forwarded row referenced by more than one row. Object ID O_ID, page P_ID1, slot S_ID1 incorrectly points to the forwarded row page P_ID2, slot S_ID2; the forwarded row correctly refers back to page P_ID3, slot S_ID3.”

This is a severity level 16 error message. After the above error message appears, the data saved in the database becomes inaccessible.


SQL database corrupted due to metadata structure damage (either due to logical or physical crash). The metadata structure corruption is causing the forwarded row (S_ID2 on page P_ID2) pointed to by an extra forwarding row (S_ID1 on page P_ID1).


The resolution for the above error message is provided in the below points:

To repair the physical damage, change the damaged system component.
To resolve the logical corruption, run the repair command “DBCC CHECKDB”.

If DBCC CHECKDB does not provides satisfactory results and the same error message appears while mounting the database, then you will need to use an efficient third-party SQL Repair application. The MS SQL Repair repairs corrupt/damaged SQL database(s) in minimum turnaround time. With few simple steps, the powerful repairing algorithms repair the database and restore the database on your desired location. Such utilities are non-destructive in nature.

SQL Recovery is a comprehensive solution to repair the SQL Server 2008, 20005, and 2000 databases. Compatible with Windows 7, Vista, 2008, XP, 2003, 2000, the SQL Database Repair software is available in both demo and full versions. The trial version can be downloaded from the Internet to preview the repairable SQL database file.

No comments:

Post a Comment