Monday, December 14, 2009

Resolving “IAM page P_ID ... that should be in filegroupFG_ID2” Error Message

Mapping of MS SQL Server database is performed over a group of operating system files. The information related to data and logs is kept in different files, while single files are handled only by one database. The collections of all these files is known as filegroup. Two major functions that every filegroup performs are placement of data and administrative tasks. Corruption in any of the filegroups primarily results in unmountability of your database, which further results in inaccessibility of database records. To access your records after your SQL Server database becomes unmountable, a simple way is to restore the data from an updated database backup. But in weird situations where you have not created any backup or backup falls short to restore the records, you will need to start searching for an advanced third-party MS SQL Repair application.

Picture a scenario where you attempt to access the data saved in one of your SQL Server database, an you receive below error message:

“IAM page P_ID for object ID O_ID, index ID I_ID controls pages in filegroup FG_ID1, that should be in filegroupFG_ID2.”

Database records stored in your database do not appear because the above error message does not allow the database to mount. In addition, you repeatedly receive the above error message each time you attempt to access the database records.


The root cause for occurrence of the above error message is damage of filegroup. Corruption can occur either due to logical or physical reasons.


Below are two measures that allow you to access database records:

Swap the physically damage component with a new component to overcome all physical damage issues.
Run DBCC CHECKDB command to surmount all logical issues.

Although the above resolutions prove successful in most cases, the possibility overcoming all logical corruption scenarios by using DBCC CHECKDB command is slightly less. In such situations, a powerful SQL Database Recovery application enables you to repair your corrupt database and access it records. Such SQL Repair tools use advance repairing procedures to thoroughly scan and repair the corrupt database.

No comments:

Post a Comment