Link to home
Start Free TrialLog in
Avatar of holemania
holemania

asked on

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?
Avatar of TonyReba
TonyReba
Flag of United States of America image

Avatar of holemania
holemania

ASKER

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?
SOLUTION
Avatar of TonyReba
TonyReba
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks guys.  Did a reboot of the server and afterward was able to remove them.