I/O Error in SQL Server | SQL Server Performance Forums

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 ‘E:DATABASESOMDEV.mdf’. Please tell your feedbacks Thanks. edpadmin
If 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)

]]>