Denise McMillan (10/31/2011)
The server adminstrators and our vendor say the drives are ok.
Those drives are not OK.
Msg 8966, Level 16, State 2, Line 1
Unable to read and latch page (1:41200) with latch type SH. 1117(The request could not be performed because of an I/O device error.) failed
Have a read through the windows system event log. My guess is you'll find IO-related errors from around the same time as the SQL DBs showed problems
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability