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.
>
>"JJ Wang" <(E-Mail Removed)> wrote in
message
>news:92db01c3b638$5c0b8af0$(E-Mail Removed)...
>> 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
>>
>>
>>
>
>
>.
>
|
Similar Threads
