Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    2

    Question Unanswered: Disk I/O Errors Error Number 823

    Has anyone come across this message when running SQL 2000 Failover clusters ?

    I/O error 2(error not found) detected during write at offset 0x00000016d44000 in file 'K:\MSSQL\Data\Int_DB_2_Data.NDF'..

    We got this message yesterday, the RAID Array was OK, the Drive could be written to using test editor directly onto the console. We restarted SQL and all came back OK. SPID 3 is the Signal Handler

    Any ideas ?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Disk I/O Errors Error Number 823

    Have you check the SQL Error log? My guess is that you may have a torn page in that database.

  3. #3
    Join Date
    Jun 2003
    Posts
    31
    I think you should do a full backup, then use this backup version to restore it on another server and run DBCC CHECKDB or DBCC CHECKFILEGROUP to make sure there is no torn page error like joejcheng mentioned. The Error 823 most likey indicate that there is potential disk problem.

    http://msdn.microsoft.com/library/de...err_1_2a0j.asp

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am chasing a similar problem on HP hardware. Make sure you get a disk consistency check done, as sometimes HP hardware is not good about checking for bad sectors, before writing to them.

  5. #5
    Join Date
    Sep 2003
    Posts
    2
    Originally posted by MCrowley
    I am chasing a similar problem on HP hardware. Make sure you get a disk consistency check done, as sometimes HP hardware is not good about checking for bad sectors, before writing to them.
    Many thanks.

    I am running DBCC CHECKDB with ALL_ERRORMSGS , PHYSICAL_ONLY first, then scheduled to run with REPAIR_REBUILD at the weekend.

    We are using an HP SAN. I will forward this onto our H/W supplier for info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •