question

half fast dba avatar image
half fast dba asked

map extent to database objec that owns it

Monday morning brought more that it's fair share of fun to the party. One of my prod. msdb databases failed checkdb. One of the error messages was Extent (1:577040) in database ID 4 is marked allocated in the GAM, but no SGAM or IAM has allocated it. how do I figure out which database object owns or is listed as owning an extent? Mumbling into my Manky Monday Coffee, (H)Alf.
objectsextent
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
Do you get an output from this query? SELECT * FROM [msdb].[dbo].[suspect_pages];
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.