SQL Server Performance Forum – Threads Archive
I/O Error in SQL Server
Hai, We are having SQl Server 2000 with NT 4.0 Sp6. some times one or more tables corrupted in our db. The message is I/O error (bad page ID) detected during read at offset 0x00000007ab4000 in file ‘EATABASESOMDEV.mdf’. Please tell your feedbacks Thanks. edpadminIf operating system, driver, or hardware problems cause lost write conditions or stale read conditions, you may see data integrity-related error messages. Refer to the KBAs
http://support.microsoft.com/kb/231619/ – HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such as SQL Server http://support.microsoft.com/default.aspx?scid=kb;en-us;828339 – Error message 823 may indicate hardware problems or system problems Check event viewer logs and run DBCC CHECKDB with REPAIR_REBUILD clause as per the books online. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Check these http://forums.aspfree.com/archive/t-18229
http://forums.aspfree.com/archive/t-18230 http://support.microsoft.com/default.aspx?kbid=826433 says need to install a service pack
You haven’t mention the error number, but most likely this is error 823 which is almost always related to hardware failure. See if this helps:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
Check your hardware *very* carefully. You might also want to consider moving to a more recent OS. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
]]>