asked
error 1167(The device is not connected.)
Several applications with databases on the server had connection interuption and the SQL Alert that is set-up forwarded this message. The operating system returned error 1167(The device is not connected.) to SQL Server during a write at offset 0x00000043f80000 in file 'E:\MSSQL10_50.LGSQL01\MSSQL\DATA\tempdb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online. What went wrong? I ran DBCC CHECKDB on all databases and no errors were returned. This event was recorded more than 10 times for different files both .ldf and .mdf on the windows event log. SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [E:\MSSQL10_50.LGSQL01\MSSQL\DataLog\xxxxx.LDF]
If it resulted in the disk being offline for any length of time, sure.
Sounds like your system lost connection to that drive. You're lucky it's all back online without any corruption. I'd check the Windows OS error log to see if there are indications there. Is this a SAN, a NAS, or a network share? If so, check the network too for errors.
15 People are following this question.
