Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have managed to get SQL Server 2008 merge replication working. However, it will occasionally fail for inexplicable reasons (currently, it's because of MSSQL_REPL-2147201021.) When this happens, our data does not get replicated for days! Our admins needs alerted when that is the case.

So, the question is: how can we be alerted when SQL Server 2008 replication fails for any reason. I also am worried about signal vs. noise. I just want to know when my data is not being synchronized and the error number that is causing the problem.

Thanks in advance for any help!

share|improve this question

Have you looked at the alerts under SQL Agent to see if the Replication alerts are enabled? You may also be able to query the destination data and see if it is getting newly dated info - if the query doesn't get expected dates, send a page.

share|improve this answer

Your Answer


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.