Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rowenaporley
Starting Member
2 Posts |
 Posted - 2009-01-30 : 02:59:40
|
| Hi to all,Is there somebody who can help me to solve our problem?We're using MSSQL 2000 running in Windows 2003. In a last few days we encountered error "I/O error 87(The parameter is incorrect) detected during read at offset 0x00000000df0000 in file 'D:\XXX\MSSQL\Data\XXX.mdf'" which caused connection broken in our query. What we always did was to restart the server for temporarily solution. I'am an accidental dba and new in our company with no experience in administering database. Guys! your help will be greatly appreciated.Thanks. |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-01-30 : 03:19:02
|
Please run the following on that DB and post the full results here.DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS Are there any errors in the windows event log?--Gail ShawSQL Server MVP |
 |
|
|
rowenaporley
Starting Member
2 Posts |
Posted - 2009-01-30 : 04:14:15
|
I already run the DBCC CHECKDB but the result was "found 0 allocation errors and 0 consistency errors in database" Other solution please....quote:
Originally posted by GilaMonster
Please run the following on that DB and post the full results here.DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS Are there any errors in the windows event log?--Gail ShawSQL Server MVP
|
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-01-30 : 15:30:16
|
| What is the error messgae in event logs and SQL Server error log: Please paste both error messages in post. Verify that you have updated HBA drivers etc. |
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2009-01-30 : 15:31:21
|
| RUN MSINFO to make sure there is no hardware issue |
|
|
|
|
|
|
I/O Error 87 (The Parameter is incorrect)