urgent! backup job fails -The process cannot access the file
JJ Wang
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? this means a disk problem or the
database was being accessed by a user or process to
prevent backup job to run?
many thanks.
JJ
Narayana Vyas Kondreddi
the file. It could well be a tape backup job, that copies this file off to a
tape drive. Do check it out.
The second error basically occurs when the file path is incorrect.
Could you copy the backup command and run it directly from Query Analyzer
and see what happens? If you get an error, post the exact error message
here.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm
"JJ Wang" <anon...@discussions.microsoft.com> wrote in message
news:7f9201c3b4cd$f84f5570$a601...@phx.gbl...
Tibor Karaszi
Etc. Remember that it is SQL Server who accesses this file, not the user who executes the backup
command.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"JJ Wang" <anon...@discussions.microsoft.com> wrote in message
news:7f9201c3b4cd$f84f5570$a601...@phx.gbl...
Linchi Shea
following OS command immeidately before the backup step and dump the output
to a text file.
nthandle.exe databaseFile3 > nthandle.log
If the backup file is being used by another process, the nthandle.log file
should show that the executable of the process has a handle on the backup
file.
You can obtain nthandle.exe from www.sysinternals.com
--
Linchi Shea
linch...@NOSPAMml.com
"JJ Wang" <anon...@discussions.microsoft.com> wrote in message
news:7f9201c3b4cd$f84f5570$a601...@phx.gbl...
JJ Wang
yes, 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.
(but I will definitely try out you guys cool commands and
give you feedback on them later.)
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
>.
>