SQL Server Performance

Merge replication is not working properly

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

  1. anujs New Member

    Hi all,

    We have SQL SERVER 2000 replication setup. Service pack 4 is installed on all Publishers and subscriber.
    Our Organization setup is as follows. We have one Head Office, 10 Range offices, 29 Circle Offices and 5 Check Gates.
    WE are using merger replication.

    Head Office is the main publisher.
    Check Gates are the subscribers to Head Office.
    Range Offices are the subscriber to the Head Office also they are Publisher to Circle Office.
    Circle offices are the Subscribers to range office.

    In turn our Hierarchy looks as

    Check Gates(Subsriber) ------> Head Office(Main Publisher)----------> Range Office(Subsriber to HO & PubLisher to Circles) --------> Circle Office (Subscriber TO Ranges)




    We are using most of the default settings while setting up the replication.

    My problem is that

    Data entered at Check Gates is replicated to the Head office & Range Office only. It is not going to the circle office.
    Is there any special setting required to replicate data up to fourth level.

    Can anybody help me in solving this problem?



    Anuj Sharma
  2. satya Moderator

    It is not going to the circle office
    Have you checked for any network issues between these 2 locations?
    Check the current activity on the SQL Server when it is running.

    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. ghemant Moderator

    Hi,

    may suggest to refer below links in this regards :

    http://support.microsoft.com/?id=315521

    www.mssqlcity.com/Articles/ Replic/troubleshooting_replication.htm

    Regards

    Hemantgiri S. Goswami
    ghemant@gmail.com
    "Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri S. Goswami
  4. anujs New Member

    Problem is not solved.

    Can I use DTS in place of replication in this senario.

    If yes, Pls tell me how to Setup DTS.



    Anuj Sharma
  5. satya Moderator

    Have you checke what has been referred above?


    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.
  6. smy New Member

    You cannot use DTS if there are records that need to be updated.
    E.g. if one table in one location is 1 and a user just update the record in the table in the other location as 2

    Replication will update the table in that location from 1 to 2.

    If DTS is used, the record will be appended instead. This will messed up the databases in different locations.

Share This Page