Backup Job Fails, but Command Works in Query Analyzer

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

From: michael [multnomah] (wewill_at_reclaimourfuture.net)
Date: 04/16/04 

Date: Fri, 16 Apr 2004 13:17:18 -0700

Hello. I am completely stuck as to why my backup job is failing. I
have a job which backs up all user databases. All of the user databases
get backed up no problem, except for one. That one fails with:

BackupDiskFile::OpenMedia: Backup device
'D:\BACKUP\EMPMART_PRD\EMPMART_PRD_db_200404161121.BAK' failed to open.
Operating system error = 32(The process cannot access the file because
it is being used by another process.).

BUT, if I run the same exact command that failed in Query Analyzer:

BACKUP DATABASE [EMPMART_PRD] TO DISK =
N'D:\BACKUP\EMPMART_PRD\EMPMART_PRD_db_200404161125.BAK' WITH INIT ,
NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

The backup succeeds every time. What is causing the backup job to fail,
but not the command when run separate from a scheduled job? There is no
anti-virus or other software that might be locking the file. It is not
a drive space or permissions issue because the same command works in
Query Analyzer. I am stuck???

Relevant Pages

  • Re: ntbackup problem with Outlook Express dbx files after XP SP3
    ... The exact command line that gets executed. ... The file/folder selections. ... in your profile folder and having a .bks extension. ... The backup job is still running. ...
    (microsoft.public.windowsxp.general)
  • IFS locks during backup
    ... I've noticed some time ago that my backup job takes more time that ... I checked backup joblog and found information that some data into IFS ... command to check in the object and then retry. ... the Work with Object Links ...
    (comp.sys.ibm.as400.misc)
  • Re: back not backing up
    ... of the account under which you ran the backup job. ... The command ... > started and then the next event says RSM was stopped. ... i have it the servers to be backed up with Scheduled Tasks ...
    (microsoft.public.windows.server.general)
  • ntbackup command line
    ... I'm creating a .bat to run a backup job and it keeps failing. ... The 4mm DAT drive is specified in the GUI but that doesn't seem to ... carry over to the command line. ...
    (microsoft.public.windowsxp.general)