DBCC CHECKDB('MSDB') returns errors

  • Sammy Balls

    SSC-Addicted

    Points: 416

    DBCC CHECKDB('MSDB') returns errors

    the following is the error

    Msg 8906, Level 16, State 1, Line 1

    Page (1:2333) in database ID 4 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.

    Msg 8906, Level 16, State 1, Line 1

    Page (1:2362) in database ID 4 is allocated in the SGAM (1:3) and PFS (1:1), but was not allocated in any IAM. PFS flags 'MIXED_EXT ALLOCATED 0_PCT_FULL'.

    CHECKDB found 2 allocation errors and 0 consistency errors not associated with any single object.

    CHECKDB found 2 allocation errors and 0 consistency errors in database 'msdb'.

    repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (msdb).

  • johnwalker10

    SSCrazy Eights

    Points: 9074

    I found this article on google, hope it helps: http://www.sqlrecoverysoftware.net/blog/sql-error-8906.html

  • Gail Shaw

    SSC Guru

    Points: 1004424

    Do you have a backup of MSDB?

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 3 (of 3 total)

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