DBCC CHECKDB('MSDB') returns errors

• Sammy Balls

  Mr or Mrs. 500

  Points: 526

  More actions

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

• johnwalker10

  SSCrazy Eights

  Points: 9124

  More actions

  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

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  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