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 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.
No comments:
Post a Comment