SQL Server Performance

Urgent: error in Replication

Discussion in 'Performance Tuning for SQL Server Replication' started by erajendar, Feb 4, 2005.

  1. erajendar New Member

    Hi all,
    After pushing the data to subscribers we want to see the data is matching in publisher and subscriber

    For matching we are running the query on the server ztxpcd2db03(subscriber)

    Use dstore

    select max(last_mod_date) from busEntity_Component


    ZTXPCD2DB03: DStore: Error: 8908, Severity: 22, State: 6 Table errors: Database ID 8, object ID 761170603, index ID 0. Chain linkage mismatch. (3:1149943)-& gt; next = (3:1149944), but (3:1149944)-& gt; prev = (3:1149941).

    After this error iam doing the DBCC DBREINDEX (‘Dstore.dbo.busEntity_Component#%92)
    This is happening only in one server. But all other subscribers are fine.
    Could you help me out.

    But the replication is successful.

    This is a push type replication.

    Thanks in Advance!!!


  2. satya Moderator

    Ensure the involved SQL server having upto date service packs and hotfixes and similar MDAC versions.
    Also check event viewer for furthe rinformation the Hardware... disks.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page