backup jobs fail due to disk I/O error

  • Thread starter Thread starter JJ Wang
  • Start date Start date
J

JJ Wang

Hi,

I have this one backup job keeps fails with the following
error message in application event log:

'18204 :
BackupDiskFile::CreateMedia: Backup device 'F:\Microsoft
SQL Server\Backup\Database\databaseFile3.bak' failed to
create. Operating system error = 32(The process cannot
access the file because it is being used by another
process.).
'

Yet, in the job history, it recorded error message like
this:

'Cannot open backup device 'F:\Microsoft SQL
Server\Backup\Database\databaseFile3.bak'. Device error
or
device off-line. '

What does this indicate? I know tape backup is not
running at the time.

it is backing up database to a local disk drive. and
this job has been running without failure for over a year
already. so I know it has no permission issue, and the
path is correct, and I double-checked.

it started to fail when my hardware people installed a
wrong memory on the server. after this, whenever the
backup job kicks off, system event log will log
unrecoverable disk read or write errors. and the backup
job will fail.

but then when you restart the backup jobs, it will succeed
in the second or 3rd runs.

today, one of the BU jobs failed again with different
messages in the job history: 'Nonrecoverable I/O error
occurred on file'.

and in the sql error even log:

1.
'BackupIoRequest::WaitForIoCompletion: read failure on
backup device 'F:\Microsoft SQL Server\data1
\databasename.mdf '. Operating system error 1450
(Insufficient system resources exist to complete the
requested service.).
'

2.
Internal I/O request 0x49D82048: Op: ReadDatabase,
pBuffer: 0x1A3B0000, Size: 983040, PageNumber: 1:6720,
UMS: Internal: 0xC000009A, InternalHigh: 0x0, Offset:
0x3480000, OffsetHigh: 0x0, m_buf: 0x1A3B0000, m_len:
983040, m_actualBytes: 0, m_errcode: 1450, File:
F:\Microsoft SQL Server\data1\databasename.mdf

3.
BACKUP failed to complete the command --BACKUP DATABASE
[databasename] TO DISK = N'G:\Microsoft SQL
Server\Backup\Database\databasename\databasenameFull.bak'
WITH INIT , NOUNLOAD , NAME = N'databasename backup',
NOSKIP , STATS = 10, NOFORMAT
BACKUP DATABASE databasename

I think this points to hardward failure/disk failure, or
disk rebuild. what do you guys think?

JJ
 
Post this to the SQL group as well as they own the backup in that product.
Typically I/O errors though are going to be hardware related. Do you have
any event IDs 9/11/15/50/51? Those are hardware related. Check the cabling
and pins on the device used for backup as well to make sure you dont just
have a frayed cable.
 
thanks, Joseph! you are very helpful!!

my disk i/o errors are of:

event id: 29, 30, 31, 34, 35, 37.

event source: dmio

JJ
-----Original Message-----
Post this to the SQL group as well as they own the backup in that product.
Typically I/O errors though are going to be hardware related. Do you have
any event IDs 9/11/15/50/51? Those are hardware related. Check the cabling
and pins on the device used for backup as well to make sure you dont just
have a frayed cable.

--
Joseph W. Conway, MCSE
Windows 9x/NT/2000/XP/2003 Server Group

This posting is provided "AS IS" with no warranties, and confers no rights.

Hi,

I have this one backup job keeps fails with the following
error message in application event log:

'18204 :
BackupDiskFile::CreateMedia: Backup device 'F:\Microsoft
SQL Server\Backup\Database\databaseFile3.bak' failed to
create. Operating system error = 32(The process cannot
access the file because it is being used by another
process.).
'

Yet, in the job history, it recorded error message like
this:

'Cannot open backup device 'F:\Microsoft SQL
Server\Backup\Database\databaseFile3.bak'. Device error
or
device off-line. '

What does this indicate? I know tape backup is not
running at the time.

it is backing up database to a local disk drive. and
this job has been running without failure for over a year
already. so I know it has no permission issue, and the
path is correct, and I double-checked.

it started to fail when my hardware people installed a
wrong memory on the server. after this, whenever the
backup job kicks off, system event log will log
unrecoverable disk read or write errors. and the backup
job will fail.

but then when you restart the backup jobs, it will succeed
in the second or 3rd runs.

today, one of the BU jobs failed again with different
messages in the job history: 'Nonrecoverable I/O error
occurred on file'.

and in the sql error even log:

1.
'BackupIoRequest::WaitForIoCompletion: read failure on
backup device 'F:\Microsoft SQL Server\data1
\databasename.mdf '. Operating system error 1450
(Insufficient system resources exist to complete the
requested service.).
'

2.
Internal I/O request 0x49D82048: Op: ReadDatabase,
pBuffer: 0x1A3B0000, Size: 983040, PageNumber: 1:6720,
UMS: Internal: 0xC000009A, InternalHigh: 0x0, Offset:
0x3480000, OffsetHigh: 0x0, m_buf: 0x1A3B0000, m_len:
983040, m_actualBytes: 0, m_errcode: 1450, File:
F:\Microsoft SQL Server\data1\databasename.mdf

3.
BACKUP failed to complete the command --BACKUP DATABASE
[databasename] TO DISK = N'G:\Microsoft SQL
Server\Backup\Database\databasename\databasenameFull.bak'
WITH INIT , NOUNLOAD , NAME = N'databasename backup',
NOSKIP , STATS = 10, NOFORMAT
BACKUP DATABASE databasename

I think this points to hardward failure/disk failure, or
disk rebuild. what do you guys think?

JJ
Click to expand...


.
Click to expand...
 
Back
Top