data doesn't be transfered to one of my subscribers!

I use merge replication and the topology is central publication. I have 20 subscribers.

when I run agent, I got message "No data needed to be merged". Publisher doesn't send data to this subscriber. When I update date again, I can send data to subscriber.

Why?!

How replication works?!

and How specifies records that must be send to the subscriber?!

Publisher and subscriber work with SQL 2000 with sp 3 installed on windows server 2003.

Please help me.

Thanks.

It's not clear what you're expecting or what the problem is.

To learn about replication, you should start by reading Replication topics in Books Online, then come back with any specific questions.

|||

I guess you have setup merge replication using "NoSync" option. See http://msdn2.microsoft.com/en-us/library/aa239398(SQL.80).aspx.

Did you see convergent data after the first sync?

Thanks.

This posting is provided AS IS with no warranties, and confers no rights.

sql

data doesn't be transfered to one of my subscribers!

I use merge replication and the topology is central publication. I have 20 subscribers.

when I run agent, I got message "No data needed to be merged". Publisher doesn't send data to this subscriber. When I update date again, I can send data to subscriber.

Why?!

How replication works?!

and How specifies records that must be send to the subscriber?!

Publisher and subscriber work with SQL 2000 with sp 3 installed on windows server 2003.

Please help me.

Thanks.

It's not clear what you're expecting or what the problem is.

To learn about replication, you should start by reading Replication topics in Books Online, then come back with any specific questions.

|||

I guess you have setup merge replication using "NoSync" option. See http://msdn2.microsoft.com/en-us/library/aa239398(SQL.80).aspx.

Did you see convergent data after the first sync?

Thanks.

This posting is provided AS IS with no warranties, and confers no rights.

Data added before publication created does not replicate - why?

Hello,

I have a small three server development environment where I am getting my feet wet with replication. I have set up peer-to-peer transactional replication and it works fine for data added to the publication's table after the publication was created. However, rows in the table that existed prior to the publication's creation have never replicated. If any of the "old" rows are edited they cause an error on the subscribing servers when the replicator attempts to apply updates to rows that do not exist.

How can I get the old rows that predate the publication to replicate?

Thanks,

BCB

I believe to setup peer-to-peer replication, you'll need to initialize the data at each node through backup and restore. You can find more info here.

http://msdn2.microsoft.com/en-us/library/ms146914.aspx

Gary