Solved

MDF file won't copy

Posted on 2010-11-17
4
380 Views
Last Modified: 2012-05-10
I have detached a database mdf file from SQL Server, but when I try to copy it, I get the error that it's being used by another process or person.  All of my programs are closed except for Windows Explorer.  What am I doing wrong?

Thank you in advance.
0
Comment
Question by:Agent909
4 Comments
 
LVL 3

Accepted Solution

by:
sasi_kmr earned 167 total points
ID: 34161916
stop the Ms SQL service and then try it.

it should work

thanks,
SASI
0
 
LVL 1

Assisted Solution

by:sachinonnet
sachinonnet earned 167 total points
ID: 34161936
some of the connection still refering to file data, try to close connections forcefully.
0
 
LVL 21

Assisted Solution

by:Alpesh Patel
Alpesh Patel earned 166 total points
ID: 34161955
Hi,

Stop SQL Server Services and do it.
0
 
LVL 1

Author Closing Comment

by:Agent909
ID: 34161965
I got it to work!  Thank you!
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now