Unable to Delete Back up File

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hi
I have a .bak file i copied it to the test server, Now when I tried to delete it from the main server i got the below error:

"Error deleting file or folder
Cannot delete [name of folder]: It is being used by another person or program. Close any programs that might be using the file and try again.

Please provide me solution.

Thanks

Posted 22-Aug-13 0:11am

tusharN

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

David Goebet · Answer 1 · 2013-08-22T00:18:00

Solution 1

try to shutdown the task that uses the file - after that you can restart the task -

Posted 22-Aug-13 0:18am

David Goebet

Comments

tusharN 22-Aug-13 6:21am

Ya i have checked all and checked about permissions also.. but still its not working

OriginalGriff · Answer 2 · 2013-08-22T00:18:00

Solution 2

The error message is pretty explicit: "It is being used by another person or program. Close any programs that might be using the file and try again."
With a database, that means SQL server, SSMS, VS or your application could be holding a reference to the file, and thus making it "in use" and not deletable. Try closing them all, and if your application opens the file directly or any reason, make sure that all streams, handles and so forth referring to the file are released or disposed when you are finished with them.

Posted 22-Aug-13 0:18am

OriginalGriff

Comments

tusharN 22-Aug-13 6:21am

Ya i have checked all and checked about permissions also.. but still its not working

OriginalGriff 22-Aug-13 6:28am

It's not a permissions problem: the file is in use. That means that an application or service has opened the file, and has not closed it yet - so you need to look and see which one it is.
How are you copying it?

OriginalGriff 22-Aug-13 6:29am

You may find this useful as well:
http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx