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

    Error

    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!!!

    Rajendar


    ok
  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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page