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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys. Did a reboot of the server and afterward was able to remove them.
http://www.sqldbadiaries.com/2011/01/04/find-the-sql-server-instance-name-using-task-manager/