SQL Server error code
SQL Server error 8996
SQL Server raises error 8996 at severity 16, which marks a problem with the query or data that you can correct.
IAM page %S_PGID for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) controls pages in filegroup %d, that should be in filegroup %d.
| Msg | 8996 |
|---|---|
| Name | DBCC3_IAM_PAGE_RANGE_IN_WRONG_FILEGROUP |
| Severity | 16 |
| Group | 8000–8999 |
What it means
The index allocation map (IAM) page P_ID in filegroup FG_ID1 incorrectly includes extents from filegroup FG_ID2. All extents for an IAM page should be in the same filegroup as the IAM page itself.