[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 912
  • Last Modified:

Unable to drop subscription in merge replication

I deleted the a push merge replication publisher but now the subscriber is still hanging out there and I can't delete it.  It says it is synchonizing.  I can't create another but the tables are being used by the phantom subscriber.  I've tried doing sp_dropmergesubscription but it can't find the publisher.  Any ideas?
0
JGarton
Asked:
JGarton
  • 6
  • 5
  • 2
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Try stopping the synchronization job
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Otherwise stop the sql server Agent
0
 
JGartonAuthor Commented:
There isn't a synchonization job.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
JGartonAuthor Commented:
Thanks.  I tried that too (just now for a second time) and that isn't releasing that subscription.  When I try to synchonize the new subscription it still tells me the tables are in use.  
0
 
bruintjeCommented:
Hello JGarton,
--------
what happens if you run
sp_removedbreplication 'databasename'
on the subscriber
--------
bruintje
0
 
JGartonAuthor Commented:
I have three other subscriptions to that same db on the same subscribers.  I will lose all of them too then, correct?  
0
 
bruintjeCommented:
more follow up on that comment
http://support.microsoft.com/kb/326352/en-us
0
 
bruintjeCommented:
yes you are correct
0
 
JGartonAuthor Commented:
I will need to get authorization to do that.  I suspect that will be the only answer.  I may be back after trying that.  Thanks
0
 
bruintjeCommented:
the problem is that you have to rebuild the other subscriptions after removing and i'm not sure if there is no other way
0
 
JGartonAuthor Commented:
Thank you so much for your help.  There are so many subscriptions and a partitioned publisher so we decided to restore the database as another name and just create new subscriptions to the publications that already exist.  We will look at using this command in the future.  
0
 
bruintjeCommented:
i read somewhere that you should be able to remove the replication on the publisher through the wizard and that it will take care of any hidden connections there is another article that might help

http://support.microsoft.com/kb/324401/en-us

thanks for the grade :)

0
 
JGartonAuthor Commented:
I tried this before I wrote you guys.  It is a great article though.  Thanks again.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now