Post reply

Merge Articles Missing after Merge Agent Runs

  • February 8, 2005 at 1:42 pm

    #87589

    I create a master database and published it. I created a second Database and published it. I subscribe my Second database as a pull to my Master. My Job status is currently Never Run. Everything looks fine until I run the job. Once I do run the job  the second database publication lists no articles but when I try to add them states it cannot because the article already exists. When I try to pull from the second database it states that it cannot get the article information. When I try to do anything with that publication such as drop it I get a list of all the tables that should be replicated and an error for each one stateing that there is a syntax error at the merge article and it cannot be removed. Any ideas?  any other information you need that might be helpful?  Were at a point where if this won't work we have to redesign the software.   (boy there not gonna like that)

     

     

  • February 8, 2005 at 6:41 pm

    #541291

    Ok so I think that its the fact that I am doing an automatic sync type  subcription is the reason I get lose all my articles. I have the correct schema at the subscriber but I need the data. Is there a way to get the data without using an automatic sync type in my agent? 

     

     

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

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