Solved

Urgent question on Merge Replication

Posted on 2003-12-11
1
533 Views
Last Modified: 2012-06-21
Hi there. I have 2 machines, one is replicating to the other. However, after a network change I want to change the roles so the the current Publisher/Distributer becomes the subscriber and vice versa. Ive deleted the publication to that subscriber, enabled the subscriber as a publisher and distributor and Now I want to replicate to the old subscriber/distributor. When I create the publication I get an error after selecting merge replication that says :
You cannot create a merge publication in Database 'RepTest'. The database contains one or more merge subscriptions that are anonymous or that use the priority of the Publisher when resolving conflicts.

To create a merge publication in this database, drop the existing merge subscriptions, create the publication, and then recreate the subscriptions'

How do I do that?? This was only ever a subscriber!! Please help!!
0
Comment
Question by:Slimshaneey
1 Comment
 
LVL 9

Accepted Solution

by:
PaulBarbin earned 500 total points
ID: 9925846
Push or pull replication?  If pull and  you haven't dropped the subscriptions to the merge replication then they are still there on the subscriber server.  

You can drop them through enterprise manager (Replication Monitor) or with the sp_dropsubscription stored procedure.

I have had some experience with subscriptions hanging around after they should have been deleted.  I find that disabling publishing and distribution, stopping the server, restarting and "re" setting up replication will almost always clear out the cobwebs.

Paul
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

679 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