By design, merge replication is very resilient.

When you say it fails to work, are you getting any replication errors or is it just the case that the network/connection that you...

Have you checked all the indexes are in place...do you have any large tables that are being replicated. If these tables are missing indexes then the replication will slow down...

Hi Lynn,

Are there any major updates or data changes of any types around the time of your increased latency ?

Are there any processes running at this time ?

Is there any...

Try using a windows account that has the right permissions.

Graeme

Hi,

Can't you simply add a job that will update the column after the snapshot has run?

HTH

Graeme

Further to my initial comment.

I made a comment that may have sounded as if I was knocking the the DBA who had been dropped in the job and struggled and...

Hi,

That's probably a question for another forum 🙂

Returning to the issue...

I've used SQL for a while now and I think I know quite a bit (enough to offer advice on...

Yes you may have to drop the subscriptions, add the articles then push out a completely new snapshot...yes not ideal.

You could set up another publication for the new article(s)...that way...

Hmmm...

When you have the concurrent snapshot option set, I think the only thing you can do is drop the subscriptions totally, add the article and resynch with a totally new...

Hi,

You should have a read about merge replication 🙂

When the merge agent runs it will apply changes that have been applied elsewhere and show the changes that it is pushing.

So...

Are you running this against the Publishing database?

Look at MSArticles in the Distribution database

Can you check that the article is actually being subscribed. I know you've added it back to the publication but check the table MSsubscriptions in the Distribution database.

The normal process...

Any ideas on why the publication might have failed...

Did it just happen or was it caused by a process ?

Have you looked at the system replication tables...the ones that store the publications and subcribers ?