We help IT Professionals succeed at work.
Get Started

Cannot delete a replication Subscription

mpdillon asked
Last Modified: 2012-08-13
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?
Watch Question
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE