Post reply

DBCC CHECKDB('MSDB') returns errors

  • January 7, 2017 at 5:01 pm

    #316802

    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).

  • January 17, 2017 at 10:59 pm

    #1923331

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

  • January 18, 2017 at 2:40 am

    #1923353

    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 2 (of 2 total)

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