question

babs2u2 avatar image
babs2u2 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]
alerts
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

If it resulted in the disk being offline for any length of time, sure.
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you Grant! This is a SAN. SQL Server 2008 R2 Standard Edition. 2 node cluster on VMware servers. Network team did find a failed disk on the storage where back-ups write. Could that failed disk cause this error?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.