Tuesday, December 8, 2009

Resolving “Text node referenced by more than one node” Error Message

Data, such as, tables, views, etc in SQL Server database is stored in blocks of 8Kb known as Pages. The two ways in which these Pages can be organized are clustered and non-clustered tables. While in clustered table the pages are linked in a doubly-linked list, the pages in non-clustered table may not be linked. Corruption in clustered table can damage the linking of the pages, further resulting in the unmountability of the SQL database. The records stored in the pages become inaccessible once the SQL Server becomes unmountable. For comprehensive accessing of all records in such situations, you will need to restore the data from an updated database backup. But if in case, the backup is corrupt, unavailable, or not even created, then you will need to use advanced third-party SQL Recovery application.

As a practical instance, you encounter the below error message while trying to access the records saved in a particular table:

“Text node referenced by more than one node. Object ID O_ID, text, ntext, or image node page P_ID1, slot S_ID1, text IdTEXT_ID is pointed to by page P_ID2, slot S_ID2 and by page P_ID3, slot P_ID3.”

Your database becomes unmountable after the above error message appears. Additionally, the error message pops up every time you attempt to access the table records.


The reason responsible for the above error message is internal errors related to three pages involved in the above error message. These internal errors could be caused either due to physical or logical crash scenarios.


Below steps enable you to resolve the problem and access your database records:

Check for physical damage of the system component. If required, change the damaged system component
If the problem persists, run DBCC CHECKDB using appropriate repair clause to repair your database.
However, if the error message still appears and no backup is available, then you will need to use powerful SQL Database Repair tool. These MS SQL Repair applications use intensive scanning methods to and repair databases and recover all database components. Such tools are completely non-destructive in nature.

No comments:

Post a Comment