msdb error

  • Hi All,

    After executing DBCC checkcatalog ('msdb') got following error message.

    Server: Msg 823, Level 24, State 2, Line 1

    I/O error (bad page ID) detected during read at offset 0x000000006b6000 in file 'e:\Program Files\Microsoft SQL Server\MSSQL\data\msdbdata.mdf'.

    DBCC results for 'msdb'.

    Connection Broken

    How can I resolve this issue. Any response will be appriciable.

  • What's the most recent backup you have for 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
  • Check the location of msdbdata.mdf file?

  • Thanks for response,

    I've checked the location of msdb database it seems ok. Is there any other way without restoration of msdb database.

    Regards,

    austin

  • Do you not have a backup?

    There is a way, but it will cause data loss. No idea how much, or from which table.

    Please run the following...

    DBCC CHECKDB('msdb') WITH NO_INFOMSGS

    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 5 posts - 1 through 4 (of 4 total)

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