Monday, November 23, 2009

How to Resolve “Table error: … out of range ...”

Nothing can be more frustrating than the inaccessibility of records stored in your database. There can be numerous reasons responsible for corruption, such as, metadata structure damage, MS SQL Server unexpected shutdown, virus attack, and more. A perfect resolution to get rid of all the corruption scenarios is by restoring the data from an updated database backup. But, there might be situations where you have either not created any backup or your backup has been damaged. These circumstances force you to use advance third party Recover SQL application that can easily repair your corrupted database.

As a practical scenario, you receive the underneath error message when you attempt to access the records stored in your SQL database:

“Table error: PAGETYPE page P_ID (object ID O_ID, index ID I_ID) is out of the range of this database.”

The above error message makes the database unmountable eventually resulting in the inaccessibility of records. Furthermore, the same error message pops up every time you attempt to access the database.


The root cause for the occurrence of the above error message is that the IAM (Index Allocation Map) page is beyond the use of the file in which it is stored. This happens when the page maps an invalid interval or the first IAM page for an index is allocated as PageId_NULL.

Note: The above error message can occur due to both logical or physical damage.


Underneath are the resolutions that help you to resolve the error caused due to either logical or physical reasons:

Run DBCC CHECKDB command to in case of logical corruption.
Thoroughly examine the application the application and Microsoft Windows system logs to identify physical damage. In case, the logs specify the physical damage, then connect the hardware.

While the above resolutions prove successful in most situations, the possibilities of DBCC CHECKDB command falling short always exists. In such cases, you will need to opt for advanced SQL Repair software. Such SQL Database Repair are easy to understand by both technical and non-technical users as they are built with highly interactive user-interface.

1 comment: