Backup fails with A nonrecoverable I/O error occurred for large DB

Hi,
We have just installed an Windows 2003 x64 server with SQL 2005 to replace
our old server. Everything seems to be working fine but the backup.
When trying to backup databases larger than 16MB or so the backup fails with
a System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file
"S:\SQLData\OLAPLogging.mdf:" 1(Incorrect function.).
(Microsoft.SqlServer.Smo) message:
Smaller DBs backup fine (master, model, etc). even if I create a new DB it
backups fine until it grows bigger than about 16MB, then it gives the same
error message.
In the eventlog I get 18210 events:
BackupIoRequest::WaitForIoCompletion: read failure on backup device
'S:\SQLData\OLAPLogging.mdf'. Operating system error 1(Incorrect function.).
Windows has latest hotfixes, latest disk drivers, tried disk caching
enabled/disabled, SQL 2005 without service pack as apps guy said no.
Hardware is DL585, 32GB of RAM, 1.4TB HP RA4100 external disk array.
Any suggestions what to try?
Thanks,
GergelySince you are getting a I/O error on drive S. Have you tried the same
backups on two or more different drives?
Ben Nevarez, MCDBA, OCP
Database Administrator
"G.Gardonyi" wrote:
> Hi,
> We have just installed an Windows 2003 x64 server with SQL 2005 to replace
> our old server. Everything seems to be working fine but the backup.
> When trying to backup databases larger than 16MB or so the backup fails with
> a System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file
> "S:\SQLData\OLAPLogging.mdf:" 1(Incorrect function.).
> (Microsoft.SqlServer.Smo) message:
> Smaller DBs backup fine (master, model, etc). even if I create a new DB it
> backups fine until it grows bigger than about 16MB, then it gives the same
> error message.
> In the eventlog I get 18210 events:
> BackupIoRequest::WaitForIoCompletion: read failure on backup device
> 'S:\SQLData\OLAPLogging.mdf'. Operating system error 1(Incorrect function.).
> Windows has latest hotfixes, latest disk drivers, tried disk caching
> enabled/disabled, SQL 2005 without service pack as apps guy said no.
> Hardware is DL585, 32GB of RAM, 1.4TB HP RA4100 external disk array.
> Any suggestions what to try?
> Thanks,
> Gergely|||Yes, same problem. Mind you it's the same external storage unit so can't rule
out some kind of HW problem. It's just weird that 'normal' operations are
running fine but when starting a backup it throws an error instantly.
"Ben Nevarez" wrote:
> Since you are getting a I/O error on drive S. Have you tried the same
> backups on two or more different drives?
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "G.Gardonyi" wrote:
> > Hi,
> >
> > We have just installed an Windows 2003 x64 server with SQL 2005 to replace
> > our old server. Everything seems to be working fine but the backup.
> > When trying to backup databases larger than 16MB or so the backup fails with
> > a System.Data.SqlClient.SqlError: A nonrecoverable I/O error occurred on file
> > "S:\SQLData\OLAPLogging.mdf:" 1(Incorrect function.).
> > (Microsoft.SqlServer.Smo) message:
> >
> > Smaller DBs backup fine (master, model, etc). even if I create a new DB it
> > backups fine until it grows bigger than about 16MB, then it gives the same
> > error message.
> >
> > In the eventlog I get 18210 events:
> > BackupIoRequest::WaitForIoCompletion: read failure on backup device
> > 'S:\SQLData\OLAPLogging.mdf'. Operating system error 1(Incorrect function.).
> >
> > Windows has latest hotfixes, latest disk drivers, tried disk caching
> > enabled/disabled, SQL 2005 without service pack as apps guy said no.
> > Hardware is DL585, 32GB of RAM, 1.4TB HP RA4100 external disk array.
> >
> > Any suggestions what to try?
> >
> > Thanks,
> > Gergely