Backup Error - File in Use

From: bd2103 (bd2103_at_discussions.microsoft.com)
Date: 12/17/04 

Date: Fri, 17 Dec 2004 14:05:02 -0800

I am running SQL Server on a Win 2003 Server box. Large Backups are scheduled
which are about 10gigs in size. I have a batch file that executes after the
backup is completed, which moves the 10 gb file to a different drive on the
same box. On random occassions, the backups fail with the following message:

"Unable to delete preexisting D:\Path\db.dat: The process cannot access the
file because it is being used by another process."

I am not sure what kind of locks could be set on the backup dat file to
prevent it from being deleted before the next backup. The only other program
accessing the backup file is the batch file I am running, which performs the
copy operation after each backup.

Any ideas on this will help... Thanks!

Relevant Pages

  • Re: Schedule Batch File-How to?
    ... backup with your Robobkup program. ... Panel> Scheduled Task etc. and the batch file name was used as the ... Windows command that you are using within the batch file. ... The properties window for the new scheduled task should now be open. ...
    (microsoft.public.windowsxp.general)
  • Using Print Migrator
    ... TCP/IP port and latest drivers from the internet. ... tool to Backup the printer information to a .cab file. ... batch file and put this in a shared folder. ... place this file in the .cab file that the tool creates. ...
    (microsoft.public.win2000.printing)
  • Re: How can I easily back up to an external hard drive?
    ... Easiest way to do this is to create a batch file and use the XCOPY command ... This may be overridden with /-Y on the command line. ... Documents & Settings folder that you use to sign in with. ... My batch file to backup my primary desktop to my server's backup drive is: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Schedule Batch File-How to?
    ... temporary that zip uses is on I: and the actual backup goes to J:. ... Panel> Scheduled Task etc. and the batch file name was used as the ... Windows command that you are using within the batch file. ... The properties window for the new scheduled task should now be open. ...
    (microsoft.public.windowsxp.general)
  • Ntbackup on windows2003 (2)
    ... >> to sort out your batch file in general. ... Backup. ... Media name: "do 27-05-2004" ... Operation: Verify After Backup ...
    (microsoft.public.win2000.general)
Loading