hi all , i have larg table (images) and i want to replicate it to two locations by the merge replication . in the first location , i was appling the merge replication for 10 months without problems. but at last week ,aftre reinilizing the publication( after generating the snapshot successfully) , i stoped the synchronization for some problems in the network line and increased the minimum and the maximum retention periods .now , when i am going to start synchronizing i receive this message :"the merge process could not perform retention-based meta data cleanup in database " and the number of rows between tow locations for this table are different . please help me quickly before to be the difference in number of rows is too large and i can't to stop the system for the long period. note : i have other publications that is replicated by transactional replication.
I was able to overcome similar situation, but unable to find correct steps forward from my library. Meanwhile review information from this KBA http://support.microsoft.com/default.aspx?scid=kb;en-us;315521]. HTH Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Check: http://support.microsoft.com/defaul...eplication_retention-based_meta_data_clean_up HTH Luis Martin Moderator SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.
thank you satya and luismartin for replying, the main problem is in the merge replication and not in retention-based meta data cleanup , will meta data cleanup make replication good or the cleanup will lose old data that is not replicated and is there any step before cleanup like reinilizing or start synchronizing ?? i want to fix my problem quickly to be two locations equilevant in number of records.
I couldn't find the correct steps to recover the issue, meanwhile is it possible to re-arrange the merge replication on the database. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.