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
 SQL Server Administration (2000)
 Urgent problem - Replication

Author  Topic 

dejjan
Yak Posting Veteran

99 Posts

Posted - 2004-12-21 : 05:22:55
Please help.
I started one week ago to work in one firm, and I have a problem. We have a merge replication with 6 subscribers. And it works fine, until Friday. Then, I had to add one more subscriber. I did something (I don't know what), and I lost all Subscribers from Rebplication/Publications/... I added one by one (with Push New subscription), but until then, there is no replication between Publisher and Subscriber, though there are a lot of changes in those databases.
When I looked Merge Agents, status is 'Succeeded' and LastAction is 'No data needed to be merged'.
Table MSmerge_contents is empty on Publisher and all Subscribers, and there are data only in MSmerge_genhistory (those data are not synchronised) and MSmerge_replinfo.
This is my first contact with replication and I make chaos. Those databases are very important for my firm so be fast.
Thanks

dejjan
Yak Posting Veteran

99 Posts

Posted - 2004-12-21 : 05:34:40
One more thing,
table sysmergearticles, where is a list of all objects that are published, is empty.
Is that all mean that I have to do it from the begining. And how to do that, and to lose all my data from Publisher and Subsribers.
Go to Top of Page
   

- Advertisement -