Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When syncing a SQL Server 2008 subscriber with a publisher, the sync fails at around 98% with this error message:

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent to apply the DDL changes and synchronize the subscription.

We have 30+ subscribers -- all of which are working except this one.

Is there any harm to other subscribers to restart the agent?

Bonus Points:

b) Is restarting the agent a good solution, or should I be looking elsewhere when I see this message?

This error message is also featured in Issue with SQL Server 2008 replication

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

I have run into this in the past. In my experience typically this will resolve it's self by just restaring the sync process. From the client in a pull situation, or restart from the publisher in a push situation.

In short the application of DDL changes ran into a conflict but restarting the sync will usually resolve the issue. And no, it doesn't start from the beginning, it should just pick up from the point of failure.

It also wouldn't hurt to make sure that your snapshot is up to date and current.

share|improve this answer
1  
We noticed that aggressive hibernate settings on the client running SQLEXPRESS (default OS install) can also cause a merge failure on a long running sync. Re-running the sync works because it has less to sync and is more likely to complete before hibernate kicks in. –  Dan Sorensen Jan 12 '13 at 0:26
    
Good to know - thanks for the update. –  RThomas Jan 14 '13 at 22:05
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.