Re: SQL I/O Errors

Tech-Archive recommends: Speed Up your PC by fixing your registry


"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: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... Our san guy is ... completely forget about is that moving the head on the disk is the slowest ... the drives that were being assigned to the SQL machine. ... I mean the binn folder which contains the sql server executable among ...
    (microsoft.public.sqlserver.setup)
  • Re: Disaster recovery
    ... I'm not familiar with REDO groups. ... use the SAN replication functionality to replicate the SQL Server data. ... "tram" wrote in message ...
    (microsoft.public.sqlserver.server)
  • SQL Server High Availability/Fault Tolerance.
    ... Node Active/Passive SQL Server 2000 Enterprise Ed. Cluster,running on ... The shared storage is on HP EVA 5000.The 2 servers and SAN are all in the ... SQL Server 2005 Standard or Enterprise Edition is considered as the DB ... After the upgrade 2 separate buildings will be used. ...
    (microsoft.public.sqlserver.clustering)
  • Re: question about disaster recovery ala virtualization
    ... If the SAN tells SQL Server "data is written" but it's stored in cache on the SAN and the SAN dies and there's no battery backup, etc. then you risk data loss. ... Lets say the motherboard on the host suddenly dies, ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server High Availability/Fault Tolerance.
    ... SQL Server 2005 Standard or Enterprise Edition is considered as the DB ... are planning to have 1 SAN and 2 SAN switches,servers, tape libraries ... Recovery solutions for the SQL Server database. ...
    (microsoft.public.sqlserver.clustering)