SQL Server Performance

SQL 2000 Merge Retention-Based metadata cleanup

Discussion in 'Performance Tuning for SQL Server Replication' started by anujs, May 8, 2006.

  1. anujs New Member

    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)-&gt;next = (1:25196), but (1:25196)-&gt<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 Sharma
  2. satya Moderator

    What 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.
  3. anujs New Member

    Service pack 4

    Anuj Sharma
  4. satya Moderator

    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.
  5. anujs New Member

    Thanks,

    It is working now.

    Anuj Sharma

Share This Page