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

Delete Publication

  
   Database Help (Home) -> Replication RSS
Next:  Natural sort  
Author Message
shadow82in

External


Since: Oct 03, 2008
Posts: 1



(Msg. 1) Posted: Fri Oct 03, 2008 3:18 am
Post subject: Delete Publication
Archived from groups: microsoft>public>sqlserver>replication (more info?)
I get following error when i Try to delete a subscription. The
Distributor and Subscribers are all not available since the network is
not available. How can i remove the subscription even when Distributor
and Subscriber servers are not available

 >> Stay informed about: Delete Publication 
Back to top
Login to vote
Paul Ibison

External


Since: Oct 03, 2008
Posts: 93



(Msg. 2) Posted: Fri Oct 03, 2008 4:21 am
Post subject: RE: Delete Publication [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You can only really start by troubleshooting the network access issues you
have. Once you have access to all the nodes in the replication setup, you'll
be able to begin removing it all.
Rgds,
Paul Ibison (www.replicationanswers.com)

 >> Stay informed about: Delete Publication 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Monitor shown publication but publication doesn't exist - I have 2 SQL Server 2000 SP3a in merge replication (1 publicator and 1 subscriptor). I added another SQL Server 2000 SP3a as subscriber; Then the publication has disappeared, the monitor shows it, but I can't run the snapshot neither replication and..

Change Publication Name - We have a problem with sp_repladdcolumn. We have publication names that have a comma in them. This causes sp_repladdcolumn not to work right. Is there a way to rename a publication without having to drop, recreate, or reinitialize? Thanks, Ken

regarding changing the option in publication - Hi Guys, If I change the schema seting in publication, or I change "copy nocluster index option" from false to true in publication for one table, I remember it will reinitialize the snapshot and recreate the table schema in subscription. But...

Publication falls to inactive - Hi all We are using a pull publication what works well. After a time, maybe next day, the publication must be reinitialized again. The duration property of the publication does not define a final date. I could not find other properties controlling th...

The initial snapshot for publication '' is not yet available - SQL 2005 - SP1 We had a server reboot last night and now my replication-monitor with message 'The initial snapshot for publication '' is not yet available on Distributor-Subscriber tab and is NOT replicating to subscriber. Upon debugging I found, my..
   Database Help (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 ]