In this blog post, let’s learn about the error message “8947 – Table error: Multiple IAM pages for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contain allocations for the same interval. IAM pages %S_PGID and %S_PGID.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
8947 – Table error: Multiple IAM pages for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contain allocations for the same interval. IAM pages %S_PGID and %S_PGID.
Reason for the Error
To be update soon…
Solution
To be update soon…