SQL Database - SQL Instance

I'm trying to move some old database to an archive folder.  However, when I do this it kept saying that it is being use.  I can't seem to find them in the SQL instance that they should be.  They had already been detached.  Is there a tool that can help me locate which SQL Instance still has it on?
holemaniaAsked:
Who is Participating?
 
Scott PletcherConnect With a Mentor Senior DBACommented:
>> If someone connect/link to this SQL instance and have it open, would that prevent me from moving the database? <<

By default, yes, but you can override that and force them off.


>> Even after detaching it from the server? <<

At that point, no.  Once the db is detached from SQL, SQL has no locks on the files, and you can copy/move the files, barring any *Windows* locks on them from someone doing something at the file level.
0
 
holemaniaAuthor Commented:
Thanks but I can't still find it.  The article said to look in Task Manager for the SQL process which I did, but it only show the one on the SQL Server I'm on.  Looking at services, there's only one and it's the same one on the SQL Server.

If someone connect/link to this SQL instance and have it open, would that prevent me from moving the database?  Even after detaching it from the server?
0
 
TonyRebaConnect With a Mentor Commented:
Probably,

Try Denying  user/login access
Do a Profiler trace
0
 
holemaniaAuthor Commented:
Thanks guys.  Did a reboot of the server and afterward was able to remove them.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.