MSDB is having logical consistency-based I/O error

  • Hello All,

    I am having below error when I run a checkdb on MSDB database.

    Msg 824, Level 24, State 2, Line 1

    SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:31; actual 1:63). It occurred during a read of page (1:31) in database ID 21 at offset 0x0000000003e000 in file 'D:\MSSQL.1\MSSQL\DATA\MSDBData.mdf:MSSQL_DBCC21'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online

    I have ran:

    DBCC CHECKDB ('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS;

    GO

    Also tried using the last option checkdb with allow_data_loss but the same error !

    Is the last backup my option ?

    Is there a way to find if the last backup is also not corrupted ?

    We also ran a health-check Hardware Drive Test/ disk check on server but everytihing looks fine :hehe:

    Thanks,

    \\K

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • Mistake ! ... double post please disregard this !

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

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

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