Solved

Urgent question on Merge Replication

Posted on 2003-12-11
1
527 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

810 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