Avatar of mpdillon
mpdillon asked on

Cannot delete a replication Subscription

I created my first replication today in SSMS. This evening I deleted the Subscriptions(2) and the Publication. I returned and recreated the Publication. That seemed to go well. Then I tried to add the Subscriptions. I get an error message saying that the Subscription already exists and cannot be created.
I created the Publication by right clicking on the Local Publication node in the Replication tree.
I created the Subscriptions by right clicking on the Local Subscripitons node and choosing New Subscription.
What I see now is under the Local Publication is the new (maybe the old, I used the same name) Publication. The new Publication node can be expanded to see two Subscriptions. I can right click on them but they will not delete. The error message is:
'Dataserver' is not defined as a subscriber for 'Dataserver'.
Could not update the distribution dataabase subscription table. the subscription status could not be changed.
Changed database context to 'mydatabase'.
Another piece of information. I backed up the publishing database prior to deleting the Subscriptions and the Publication. After restoring the database using SSMS is when the trouble began. Below is the timeline.
Created New Local Publication
Created Two Local Subscriptions
Backup Database
Enter transactions but needed to restore the database
Deleted both subscriptions. Deleted the Publisher.
Restored the database through SSMS.
Created a new Local Publication
Tried to add one New Subscription (Received the Already Exists message)
Noticed under the Local Publication node the following nodes.
    Product tables Publication
          Database1 Subscription
          Database2 subscription
The Local Subscription node is empty
How do I straighten this mess out?
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

No responses and this solved my problem
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck