Can't detach database

I have a database I want to copy to a second server. The
simplest way seems to be detach, copy DB & Log files,
attach.
However, I can't detach the database. When I attempt to
detach it, it says there is 1 process connected. If I
look in the management tool, there are no processes
connected.
This is a dedicated server. I shut it down, disconnected
it from the network, then restarted. The only connection
shown is the management console I am using for the detach.
But it still shows 1 connection to the database I want to
detach.
Any help is greatly appreciated.Are you by any chance the 1 user in the database?
Try directly from QA without even starting Enterprise Manager executing the
following:
USE MASTER
Go
SP_DETACH_DB YourDB
HTH,
Des
On 24/11/2004 15:27, in article 995b01c4d231$b9ccbe50$a301280a@.phx.gbl, "DB"
<anonymous@.discussions.microsoft.com> wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.|||I've the same issue once that what i do.
First be sure that you don't have replication enabled on the database (as a
publisher or published DB)
2nd.
On EM try to dettach the DB, immediatly go to Query analyzer and run
sp_who2, look for bloking sessions,the one that is blocking should be the on
e
that is avoiding the DB to be dettahced.
This should be enough to solve the issue.
Regards.
Frivas
"DB" wrote:

> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.
>|||Make sure your Object Browser is closed, if you have it open.
"DB" <anonymous@.discussions.microsoft.com> wrote in message
news:995b01c4d231$b9ccbe50$a301280a@.phx.gbl...
> I have a database I want to copy to a second server. The
> simplest way seems to be detach, copy DB & Log files,
> attach.
> However, I can't detach the database. When I attempt to
> detach it, it says there is 1 process connected. If I
> look in the management tool, there are no processes
> connected.
> This is a dedicated server. I shut it down, disconnected
> it from the network, then restarted. The only connection
> shown is the management console I am using for the detach.
> But it still shows 1 connection to the database I want to
> detach.
> Any help is greatly appreciated.