asked on

Cannot copy backup. The process cannot access the file because another process has locked a portion of the file.

I have a .BAK file that I like to copy to another server. The .BAK file is 26GB. When I copy it, I receive the following error and the file is not copied:

Cannot copy backup. The process cannot access the file because another process has locked a portion of the file.

Any suggestions on how to copy the file? I am using SQL Server 2005 and Windows 2003 Server.

Thanks

Raja Jegan R

If it is a backup set, check whether any backup or restore operations are going on from that backup set ( Backup set holds multiple backups).
Or else check for any other Windows process like De fragmentation running on the disk which might lock your backup file.

ASKER CERTIFIED SOLUTION

mds-cos

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gtrapp

ASKER

Its not a backup set. I selected to overwrite all existing backup sets.

I can not find a defrag process running on the server, although there is a nightly process on the server for defragging.

I will try rebooting the server.

Raja Jegan R

>> Its not a backup set. I selected to overwrite all existing backup sets.

If so, then check whether you have a backup job scheduled in your maintenance plan accessing this file..

gtrapp

ASKER

I ran the backup manually.

Raja Jegan R

Ok.. Just kill explorer.exe and start a new explorer.exe from your Task manager instead of a system restart..

Máté Farkas

First, you should use OpenedFilesView to find what is locking the backup file.

gtrapp

ASKER

I have already look there, nothing is locking the file.

gtrapp

ASKER

I have killed EXPLORER.EXE and started a new process. I am trying the copying again.

gtrapp

ASKER

I rebooted the server and that fixed the problem. I was able to copy the file. There were no process using the file.