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.> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--B_3184155358_1551408
Content-type: text/plain;
charset="ISO-8859-1"
Content-transfer-encoding: 8bit
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.
--B_3184155358_1551408
Content-type: text/html;
charset="ISO-8859-1"
Content-transfer-encoding: quoted-printable
&

---

Re: Can't detach database
Are y=ou 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, &qu=ot;DB" wrote:
> I have a database I want to copy to a second ser=ver. 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.
--B_3184155358_1551408--|||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 one
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.