Thursday, December 9, 2010

Fixing “cannot be placed on a page of type PAGE_TYPE” Error Message

A table in MS SQL contains numerous rows, each containing a different set of information. These rows are stored in multiple partitions, which are structured in heap or B-tree format. The actual information saved in these rows is stored in the leaf nodes (text data node). Each leaf node has its parent node that keeps critical information related to that node. However, there are some situations when the text data node points to a wrong parent node or the parent node does not even exist. These situations primarily occur due to corruption of SQL database. To overcome such corruption cases, the user will need to restore the data from an updated backup. However, if no backup is available ,then s/he can opt for effective SQL Database Repair tool to repair the corrupted database.

The below error message might pop up while accessing the database table:

“Table error: The text, ntext, or image node at page P_ID, slot S_ID, text ID TEXT_ID has type NODE_TYPE. It cannot be placed on a page of type PAGE_TYPE.”

The error message has severity level 23.


The error message occur because:

The parent node could not be found.
The text node is pointing to a wrong parent node.

This occurs when the SQL Server database is damaged either physically or logically.


Underneath are some guidelines that help you to surmount the above error message:

For all kinds of possible hardware problems, you should first check system logs, application logs, and SQL Server logs. In case you find any physically damaged system component, then you need to swap it with a new system component.
Restore the data from an updated backup.
For all kinds of logical crash scenarios, you should execute DBCC CHECKDB command with correct repair clause.
While the above command repairs a logically corrupted database, it may also result in loss of data. To avoid such situations, you should use effective third-partysql database repair application to resolve logical corruption. These SQL Repair tools employ powerful, yet safe repair techniques to repair the database.

No comments:

Post a Comment