November 6, 2016 at 7:14 am
When I run DBCC CHECKALLOC on a database I get the following error
DBCC results for 'MYDB'.
Msg 8906, Level 16, State 1, Line 1
Page (1:3621975) in database ID 8 is allocated in the SGAM (1:3578625) and PFS (1:3615336), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.
CHECKALLOC found 1 allocation errors and 0 consistency errors not associated with any single object.
***************************************************************
How can I fix it?
Thank you
November 6, 2016 at 11:59 am
Please don't post multiple threads for the same question.
No replies here. Direct replies to http://www.sqlservercentral.com/Forums/Topic1832272-2893-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply