missing of data in merge replication.

From: Indra (itimilsina_at_savannaenergy.com)
Date: 09/30/04

  • Next message: George Randall: "Re: Merge SQL 7 to 2000 problem" 
    Date: 30 Sep 2004 13:20:22 -0700

    Hi there,

    we are using merge replication with anonymous subscribtion.

    window 2000, sql 2000 sp3 - server

    wind 2000/XP, msde 2000 sp3 - subscriber

    Synchronizing data with Active XControl.

    we have around 50 subscriber and in our database we are using identity
    range management(defult by server) and static filter also. every
    things working fine except some time we donot get data from the
    subscriber after synchronization. Subscriber does not display any
    error message and it say synchronization done successfully but when we
    check data its not there in server but still there in subscriber.

    when i connect to subscriber and just re-enter same vaule or just
    updata one character in a set and synchronize all the data come to
    server. since we have 50 + subscriber it pain for us to check around
    10-15 subscriber having this type of error. I am suspecting is there
    any kind of bug in replication or what causing this problem. if
    Microsoft or any one having information regarding this problme please
    let me know. I am thinking to open PSS for this in Microsoft but
    before i contact them i wanted to know if any one else also having
    similar problme or if there is any way to fix this problem.

    Thanks you in advance.

    Indra.

  • Next message: George Randall: "Re: Merge SQL 7 to 2000 problem"

    Relevant Pages

    • Re: SQLEXPRESS Replication?
      ... The way the Technet SQL BOL is arranged it is difficult to know just how to setup the required permissions to do replication which is the major stumbling block. ... You can replication from SQL Server 2005 Workgroup edition and above ... to a SQL Server Express subscriber using transactional replication. ...
      (microsoft.public.sqlserver.replication)
    • Re: replicated commands not executed on the subscriber side?
      ... My current environment is the most complex sql server environments in my 10+ ... Unlike the replication procedure when changes made at Subscriber, ...
      (microsoft.public.sqlserver.replication)
    • Re: transactional replication problem
      ... If the distribution agen can't connect to the subscriber, ... Looking for a SQL Server replication book? ... > server B. Problem is with only one database. ...
      (microsoft.public.sqlserver.replication)
    • Re: replication latency
      ... Your problem is that you should be using merge replication. ... occurring on the subscriber. ... Looking for a SQL Server replication book? ... Publication FULL: Transactional/Immediate updating subscriptions ...
      (microsoft.public.sqlserver.replication)
    • Re: Merge and transactional replication
      ... For server to server replication, ... mean most transactions originate on the server, ... Your publisher and subscriber will ...
      (microsoft.public.sqlserver.replication)