Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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

 
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.