Prev: merge replication and structure changes
Next: High availability for Replication
From: Eugene on 1 Aug 2008 05:39
Hi All,

I have problem with deleting my replication. I restored a database given
from another server, and with it, it comes with subscriber that points to
another database server. Now, when I want to remove the publication with
sp_droppublication, then it tells of subscription still exist. Then I try to
run
sp_dropsubscription and sp_dropsubscriber, but it still fails when i rerun
sp_droppublication. I don't know where have I missed out. To compound to the
problem, I have a computer name change prior to this. I have executed
sp_dropserver and sp_addserver. I have two publication that I want to delete
now, but somehow, after i run the sp_dropserver/sp_addserver, only one of the
replication had the publisher name changed. What should I do? What is the
proper steps now?

Many thanks.
From: Hilary Cotter on 2 Aug 2008 08:13
did you try sp_droppublication 'publicationname',@ignore_distributor=1
"Eugene" <Eugene(a)discussions.microsoft.com> wrote in message
news:25E44D07-B8B0-49E4-9E52-E1643C098FB6(a)microsoft.com...
> Hi All,
>
> I have problem with deleting my replication. I restored a database given
> from another server, and with it, it comes with subscriber that points to
> another database server. Now, when I want to remove the publication with
> sp_droppublication, then it tells of subscription still exist. Then I try
> to
> run
> sp_dropsubscription and sp_dropsubscriber, but it still fails when i rerun
> sp_droppublication. I don't know where have I missed out. To compound to
> the
> problem, I have a computer name change prior to this. I have executed
> sp_dropserver and sp_addserver. I have two publication that I want to
> delete
> now, but somehow, after i run the sp_dropserver/sp_addserver, only one of
> the
> replication had the publisher name changed. What should I do? What is the
> proper steps now?
>
> Many thanks.

From: Eugene on 5 Aug 2008 23:37
Hi Hilary, thanks.

I tried that sp_droppublication with the ignore distributor param. But it
gave me a "A subscription exists to it." error. I proceed to try
sp_dropsubscription @publication = 'all', @subscriber = <subscriber>,
@article = 'all', but then this give me Msg 20032, <Subscriber> is not
defined as a Subscriber for <My local server name>.

What should I do?

Thanks
Eugene

"Hilary Cotter" wrote:

> did you try sp_droppublication 'publicationname',@ignore_distributor=1
> "Eugene" <Eugene(a)discussions.microsoft.com> wrote in message
> news:25E44D07-B8B0-49E4-9E52-E1643C098FB6(a)microsoft.com...
> > Hi All,
> >
> > I have problem with deleting my replication. I restored a database given
> > from another server, and with it, it comes with subscriber that points to
> > another database server. Now, when I want to remove the publication with
> > sp_droppublication, then it tells of subscription still exist. Then I try
> > to
> > run
> > sp_dropsubscription and sp_dropsubscriber, but it still fails when i rerun
> > sp_droppublication. I don't know where have I missed out. To compound to
> > the
> > problem, I have a computer name change prior to this. I have executed
> > sp_dropserver and sp_addserver. I have two publication that I want to
> > delete
> > now, but somehow, after i run the sp_dropserver/sp_addserver, only one of
> > the
> > replication had the publisher name changed. What should I do? What is the
> > proper steps now?
> >
> > Many thanks.
>
 | 
Pages: 1
Prev: merge replication and structure changes
Next: High availability for Replication