Fixing “cannot be placed on a page of type PAGE_TYPE” Error Message - By: Adishree Singh

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.

Cause

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.

Resolution

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-party sql database

repair application to resolve logical corruption. These SQL Repair tools employ powerful, yet safe repair techniques to

repair the database.

SQL Recovery is an outstanding application to repair and restore MS SQL Server 2008, 2005, and 2000 databases at

specified location. The ms sql repair software is designed for Windows

7, Vista, 2008, XP, 2003, and 2000. It performs safe repair of almost all SQL database objects, including, table and views.

About the Author

Adishree Singh work as a freelancer and researcher repair sql database & sql repair software.

Article Directory Source: http://www.articlerich.com/profile/Adishree-Singh/65835

Additional Articles From - Home | Computers | Data recovery