I'd like to detatch a database but I am told the following:
ATTENTION:the database cannot be detached while it is being replicated.
I was going to stop the replication but when I look in the 'Replication'
node in Enterprise Manager for that server there are no Publications or
Subscriptions listed there. Why can't I detatch the DB?
Cheers,
elziko
you have to disable the database for replication to detach it.
Go to Tools, Point to replication, configure publishers, subscribers,
distributor, and click on the publication databases tab, and disable the
database this way.
"elziko" <elziko@.NOTSPAMMINGyahoo.co.uk> wrote in message
news:ehqJ021YEHA.1180@.TK2MSFTNGP10.phx.gbl...
> I'd like to detatch a database but I am told the following:
> ATTENTION:the database cannot be detached while it is being replicated.
> I was going to stop the replication but when I look in the 'Replication'
> node in Enterprise Manager for that server there are no Publications or
> Subscriptions listed there. Why can't I detatch the DB?
> --
> Cheers,
> elziko
>
Friday, March 9, 2012
Replication & Detatching
Labels:
database,
detached,
detatch,
detatching,
followingattentionthe,
microsoft,
mysql,
oracle,
replicated,
replication,
server,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment