Post reply

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

  • February 2, 2012 at 8:00 pm

    #267640

    HI All,

    I am getting below error when try to access object in database.

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

    I/O error 21(The device is not ready.) detected during read at offset 0x0000000001c000 in file 'Y:\MSSQL\DATA\GLC2005.mdf'.

    Connection Broken

    and also observe some different error when running dbcc checkdb.

    Server: Msg 8966, Level 16, State 1, Line 1

    Could not read and latch page (1:8) with latch type SH. sysobjects failed.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    Please suggest your best.

  • February 3, 2012 at 4:10 am

    #1442285

    Restore from a clean backup and check what is wrong with the IO subsystem for it to be throwing that error (something is wrong)

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

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