SQL Server Performance Forum – Threads Archive
SQL 2000 Merge Retention-Based metadata cleanup
Hi all, I am a new member of this forum.<br /><br />I am getting problem in SQL 2000 Server replication. <br />I am getting following message in one of my replication subscription.<br />Can anybody help me in solving this problem?<br /><br /><br />The merge process could not perform retention-based meta data cleanup in database ‘OSTIS_LUHURACHATI’.<br />(Source: Merge Replication Provider (Agent); Error number: -2147199467)<br />—————————————————————————————————————<br />Table error: Database ID 7, object ID 1337875933, index ID 0. Chain linkage mismatch. (1:18706)->next = (1:25196), but (1:25196)-><img src=’/community/emoticons/emotion-4.gif’ alt=’;p’ />rev = (1:25195).<br />(Source: LHRCCG (Data source); Error number: 890<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /><br />—————————————————————————————————————<br /><br />Anuj SharmaWhat is the Service pack level on SQL Server? Satya SKJ
Microsoft SQL Server MVP
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.
Service pack 4 Anuj Sharma
Stop the merge agent and perform a DBREINDEX on the involved tables. Satya SKJ
Microsoft SQL Server MVP
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.
Thanks, It is working now. Anuj Sharma
]]>