SQL Server Performance Forum – Threads Archive
Replication Error – Please Help!
Hi, I have had replication working pretty well for a couple of weeks. Then one day on one of the subscribers, I noticed that all of the subscriptions had failed. Without doing any investigating, I simply hit the "Start Synchronizing" button, and they came back to life. Then the next day it happened again, only this time they wouldn’t start synchronizing after I hit the "Start Synchronizing" button. I checked the error message on all of them, and it said: The merge process could not retrieve generation information at the ‘Subscriber’ Another piece of information is that the 2 other subscribers have continued to work this whole time. Hmmmm. Does anyone have any ideas? I am at my wits end here. Any help would be unbelievably appreciated. Thanks in advance. Scotthttp://msdn.microsoft.com/library/en-us/dnsql2k/html/sql_replmergepartitioned.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergproc.mspx Also confirm the service pack levels on SQL Servers that are involved in this replication process. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>