Post reply

MSDE Replication Problem

  • May 30, 2006 at 11:59 pm

    #103172

    Hello,

    I am using MSDE 2000 for replication of my Data. I have one publisher and two subscribers. but i need t filter rows for publications. Problem is that for filtering, i need host_name and in push replication host_name is name of system in which Agents are running but in MSDE all agents are running in publisher system ( distributor System). so everytime for any publication i get only id of server.

    i am facing same problem in pull replication also.

    Regards,

  • June 1, 2006 at 1:52 pm

    #641298

    So you are saying that the suscriber are in the server too ?, can you explain a litte more about your suscriber and publisher. How can you have the Agent for a suscriber in the publisher ?

    Pedro R. Lopez
    http://madurosfritos.blogspot.com/[/url]

  • June 1, 2006 at 10:51 pm

    #641356

    I think I understand your problem. You are saying that because the push agents are running the publisher (i.e. you have a two tier topology) the host name that the agent uses is actually the host name of the publisher/distributor. Correct?

    In that case, you need to override the hostname value in the "Run agent" step of the job by using the "-Hostname" parameter. See the Books Online for the relevant agent (transactional, merge, snapshot) for more information or feel free to ask more questions.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply