Re: SQL I/O Errors

Hi John

Thanks ever so much for this, it was in fact the fibre cable between the SQL
server and the SAN, we replaced the cable and found that the I/O errors and
related speed issues were resolved!

Thanks again

Chris Dodson

"John Bell" wrote:


"Chris Dodson" <Chris Dodson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F6604A5C-F50F-4293-8ACF-EE8F598A5FDB@xxxxxxxxxxxxxxxx
Hi there

We have a major problem with our Test SQL Server, we are receiving
constant
I/O errors when attempting to perform backups.

SQL Data resides on the E Drive which is SAN Fibre attached, the logs also
reside on this drive. I have attempted to put all Data and Logs onto local
drives and we also recieve the same I/O Errors!

The exact error is as follows:

BackupIoRequest::WaitForIoCompletion: read failure on backup device
'E:\MSSQL.1\MSSQL\Data\Helpdesk.mdf'. Operating system error 1117(error
not
found).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Event ID 18210.

The server is running Windows 2003 64bit SP2 with all the latest updates
installed, the hardware is a HP Proliant Blade BL460c, with all the most
recent firmware/drivers installed.

At first we thought it was an Operating System fault and completely
rebuilt
the system, however the problems still occur. We have multiple SQL Servers
running on the same HW without any problems.

Can you guys help here?

Thanks

Hi Chris

Error 117 is also

"The request could not be performed because of an I/O device error."

It looks like there is probably issue with the SAN, have you tried copying
some large files to/from the E drive using the command prompt?

How is the cache configured on the SAN? Are these different to other servers
using the SAN?

When you rebuilt the system did you replace or at least re-seat HBAs and any
other components?

John



.

Relevant Pages

  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Add new cluster and use existing LUNs?
    ... Meta-volumes are dedicated to a single host, single activity (OS, swap file, ... varied activity (DBMSes, Messaging Server, File Server, Web Servers, ... Some of the physical spindle limitations can be addressed through the SAN ... >> test would be to run a simulated SQL I/O load on the newly created LUNs ...
    (microsoft.public.sqlserver.clustering)
  • Re: Multi-Channel Raid VS SAN Storage
    ... The server itself is about 5 and a half years old. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Login Failed
    ... Thanks Hari, here is the result after using sqlserver.exe -c ... Operating system ... > Try starting SQL Server from command prompt. ...
    (microsoft.public.sqlserver.clients)