Fixing Index Allocation Error 8947

Pages that contain information about the extent that SQL table/index uses are called Index Allocation Map (IAM) pages. Errors in multiple IAM pages causes corruption in the repair SQL database, which makes you to repair SQL. Given below is the error message that you may encounter after corruption in the multiple IAM pages:

Server: Msg 8947, Level 16, State 1
Table error: Multiple IAM pages for object ID O_ID, index ID I_ID contain allocations for the same interval. IAM pages P_ID1 and P_ID2.

Above-mentioned error message simply indicates corruption in IAM pages. Now, when you know the reason behind the error message, do not you want to know what makes IAM pages to be corrupt? Obviously, you would like to know the cause of IAM pages damage. The prominent reason behind this is hardware failure.

Failure in any hardware may cause the SQL database to be damaged generating the need to repair SQL database. Now, when you have known the reason behind the issue listed above, let us tell you the process to deal with the issue. Listed below are the methods that will help you to resolve the issue:

• Check Windows and SQL Server logs to see which hardware failure has caused the issue. Based on the information provided in the log files, execute hardware diagnosis or replace the faulty hardware. Doing this will resolve the issue.
• If the issue is not resolved even after executing the hardware diagnosis or replacing the faulty hardware, you have to repair SQL database file or replace the existing database file with its backup copy.

You are suggested to replace the existing file with the backup copy, as this is the most convenient method to continue using SQL without any hitch. However, if you do not have backup of the SQL database file, you are only left with repairing SQL.

Try using SQL Repair software to repair SQL database file in few mouse clicks. This easy to install and use repair SQL software performs quick and impeccable database recovery. Whether you use SQL Server 2000, 2005, or 2008 you can use this software to repair SQL file.