Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 2 way merge replication

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-07 : 09:08:31
raj writes "Hi All

I would really appreciate it if someone tells me why the following replication scenario happens on SQL 2000

I have 2 servers x1 and x2 each having a database say DB.
I first set up a 1 way merge replication for DB from x1 to x2 with a publisher on X1 and subscriber on X2. Things were fine with updates reflecting from x1 to x2. Then i went ahead and tried to create a publisher on x2 and x1 subscribes to x2. There was an issue creating the publisher on x2. I then deleted the publisher on x2.

What is happening is x1 updates to x2 is fine and even updates from x are being reflected on x1.?

Both the machines though are configured to be subscribers and publishers (using tools->replication->configure .....
But there is no publisher on X2..


Thanks
Raj"
   

- Advertisement -