Data file I/O Error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Data file I/O Error

Hi Gurus, I have Got this Error while Inserting some New Rows in the database I/O error (bad page ID) detected during read at offset 0x0000000dffa000 in file ‘C:DATAdata.mdf’. could you tell me the reason for this error and What is the fastest solution
for this.
raj
Probably hardware errors. Check for any entries in log files and check closely your hardware. This might also be helpful:http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Check event viewer log also for any more information.
CHeck this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;826433 for information. 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.
Hi Gurus, Ok it is Hardware related Problem.But, What is the Solution
for this ? How do I recover data ?
Thanks raj
Check the related errors in event viewer and refer to the hardware vendor.
Ensure to take full databases backup for system and user databases and store them in secure location (test the backups before hand). 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.
Replace the corrupt hardware and restore from the last good known backup. What recovery model do you have? —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Probably take System administrator’s help for the hard ware problem. 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.
Hi I have Full REcovery Model.Thanks for the Help.
I fixed the problem by restoring the database to a different Harddisc. Thanks, raj
]]>