Post reply

I/O 823 error

  • October 6, 2003 at 8:23 am

    #160163

    here is the error that I have got during my weeckly data load:

    Executed as user: sa. I/O error (bad page ID) detected during read at offset 0x000000bf074000 in file 'f:\SQL data files\data files\dw_prod.mdf'.

    [SQLSTATE HY000] (Error 823). The step failed.

    What can I do to make it work.Please help

    Thanks

  • October 6, 2003 at 9:08 am

    #477204

    please help

  • October 6, 2003 at 9:17 am

    #477207

    823 Error messages usually imply on disk corruption most typically arising from problems at a level below the operating system (e.g. Hardware component failure, bad/outdated device driver, or external

    failure such as an unfiltered power surge). When only 823 errors are observed, You should perform CHECKDB on your database and identify last known good clean backup for recovery needs.

  • October 6, 2003 at 9:22 am

    #477209

    I am running DBCC now and I am waiting for the putcome.

    I have a 100 G database and the recovery will be a headache.

    Do you suggest a hardware checek before we recover?

    Thanks

  • October 6, 2003 at 9:28 am

    #477211

    Check your machine application/system logs and perform hardware check before going to restore your database.

  • October 6, 2003 at 10:01 am

    #477218

    My DBCC came out with 7 consistency errors

    I am running dbcc checkdb with REPAIR_REBUILD option

    Thank you

    lavinia

Viewing 6 posts - 1 through 5 (of 5 total)

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