Solved

Replication  subscription cannot be created because it exists already - but it doesn't

Posted on 2008-10-06
2
353 Views
Last Modified: 2012-05-05
Despite refresh - and restarting services. Wizard insists that it exists and fails on the final step.
Why does it think it exists when there are no subscriptions visible in Enterprise manager?
Publisher exists, one publication.
The subscriber is also the distributor.
While the publication (snapshot) was being made, I deleted the original subscription because it was "transaction" not snapshot, and I thought that was probably not right.
 All seemed ok, but now I cannot recreate a subscription of any type.

0
Comment
Question by:awalkinthepark
2 Comments
 
LVL 29

Accepted Solution

by:
mass2612 earned 125 total points
Comment Utility
Hi,

The only thing I can think of is to try to cleanup/reset the replication by removing everything using the stored procedure sp_removedbreplication.

sp_removedbreplication (Transact-SQL)
http://technet.microsoft.com/en-us/library/ms188734(SQL.90).aspx
0
 
LVL 1

Expert Comment

by:carlosmonte
Comment Utility
Hi awalkinthepark,

I have the same situation happening.
I even deleted everything and recreated the replication with different names and still i cannot see the subscription at the subscriber/distributor.

Really would appreciate any suggestions.
I can even open another question if needed.

thanks
CM
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now