What database is this referring to? -- Table error: IAM page

Question

Post reply

What database is this referring to? -- Table error: IAM page

josephollero

SSC Enthusiast

Points: 122
More actions
September 25, 2018 at 9:26 pm

#363495

Hello,
Is it possible to find out what database or maybe even table the log below is pointing to? I thought I know what database this is but I am not sure anymore. Any way to find out?
Table error: IAM page (1:1128143) for object ID 0, index ID -1, partition ID 0, alloc unit ID 72059652866375680 (type Unknown) is linked in the IAM chain for object ID 1497165209, index ID 1, partition ID 72059649171390464, alloc unit ID 72059652874764288 (type In-row data) by page (0:0).
Thanks in advance!
Regards,
Joseph

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Joe Torre SSChampion Points: 10248 More actions · Answer 1

What do you get with:
SELECT Object_Name(1497165209) ObjName

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

josephollero - Tuesday, September 25, 2018 9:26 PM
Hello,
Is it possible to find out what database or maybe even table the log below is pointing to? I thought I know what database this is but I am not sure anymore. Any way to find out?
Table error: IAM page (1:1128143) for object ID 0, index ID -1, partition ID 0, alloc unit ID 72059652866375680 (type Unknown) is linked in the IAM chain for object ID 1497165209, index ID 1, partition ID 72059649171390464, alloc unit ID 72059652874764288 (type In-row data) by page (0:0).
Thanks in advance!
Regards,
Joseph

Are there other error messages around that error? Those may help in determining the issue.

josephollero SSC Enthusiast Points: 122 More actions · Answer 3

Joe Torre - Wednesday, September 26, 2018 10:58 AM
What do you get with:
SELECT Object_Name(1497165209) ObjName

A appreciate the reply Joe.

That is the strange part. I ran that on all of the databases I have on the server and I got NULL. That includes the system databases.

josephollero SSC Enthusiast Points: 122 More actions · Answer 4

Lynn Pettis - Wednesday, September 26, 2018 12:01 PM
Are there other error messages around that error? Those may help in determining the issue.

I appreciate the reply Lynn!

Yes I did check all of the messages. In fact that error is recurring. I saw no direct implication on to what database it is referring to. I thought I know where it was but DBCC CHECKDB proves me wrong.