Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Remove push subscription from subscriber

 
   Database Forums (Home) -> Replication RSS
Next:  Incremental Article Additions to an Existing Merg..  
Author Message
Francesco

External


Since: Feb 05, 2008
Posts: 1



(Msg. 1) Posted: Tue Feb 05, 2008 12:01 pm
Post subject: Remove push subscription from subscriber
Archived from groups: microsoft>public>sqlserver>replication (more info?)

Hi everyone.

I have an SQL Server 2000 "A" pushing a transactional replica of a
database on an SQL Server 2000 "B".
Today i removed the subscription from server "A" (publisher), but i
still see the subscription on the server "B" (subscriber).
I tried

sp_subscription_cleanup 'publisher', 'publisher_db'

the command runs, no effect, the subscription is still there. What am i
doing wrong?

Thank you for your time.

--
Francesco

 >> Stay informed about: Remove push subscription from subscriber 
Back to top
Login to vote
Hilary Cotter

External


Since: Oct 09, 2005
Posts: 78



(Msg. 2) Posted: Thu Feb 07, 2008 5:56 am
Post subject: Re: Remove push subscription from subscriber [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

What do you mean by you still see the subscription on ServerB>

All objects replicated by the replication process will remain on the
subscriber, once you drop the subscription.

On Feb 5, 10:07 am, Francesco wrote:
> Hi everyone.
>
> I have an SQL Server 2000 "A" pushing a transactional replica of a
> database on an SQL Server 2000 "B".
> Today i removed the subscription from server "A" (publisher), but i
> still see the subscription on the server "B" (subscriber).
> I tried
>
> sp_subscription_cleanup 'publisher', 'publisher_db'
>
> the command runs, no effect, the subscription is still there. What am i
> doing wrong?
>
> Thank you for your time.
>
> --
> Francesco

 >> Stay informed about: Remove push subscription from subscriber 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
What Access do publisher servers need with push subscripti.. - When setting up security access between a publisher and subscriber, what needs to be done? I can't find a checklist of things to do when setting up connection and access details from a publisher to a subscriber - is there something online anywhere? ....

Merge Subscription Database move to new Server - I want to move Merge Pull Subscription database to New server(Hardware) without dropping subscription. Note: I do not want copy master and msdb database to new server because collation is different from subscription database. OS : Windows 2003..

Publish Subscription replication - Side effects? - Hi Guys, I've been given the task of creating a disaster recovery "replica" of a production SQL server and keeping it current. (SQL 2000) At first we thought of using scripts to do a backup/restore method. But a couple of the databases are u...

stored_procedure execution replication on No-sync subscrip.. - is it possible to add stored_procedure execution replication to non- sync transactional replication ? I can't find BOL docs about this. I can add it to the publication but nothing is logged on the distributor when I invoke it. Any thoughts ?

3930 when pushing subscription to a snapshot replication p.. - We are attempting to use snapshot replication to push data from one SQL Server 2005 server to another SQL Server 2005 server. We had no trouble creating the publication, but when we try to create a new push subscription we get the failure below..
   Database Forums (Home) -> Replication All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]