hi all, i am having serious problem with merge replicatoin on sql server. our merge agent is going down for different erros some times network and sometimes something else when i try to restart the agent it is restarting but to connect to other side of sql server it is taking forever. something like 8 to 10 hours. Now my first idea was something has gone wrong with the network. but transactional replication between the servers is running fine. please advise, does it happen due to the hung pids on the subscriber side or merge partner we can say. Thanks in advance, please through some ideas.
Check the following articles which may help you... How to enable replication agents for logging to output files in SQL Server http://support.microsoft.com/kb/312292/ How to troubleshoot SQL Server merge replication problems http://support.microsoft.com/kb/315521 And also Read the following article... http://blogs.msdn.com/sqlservercomp...ion-compatibility-sql-server-compact-3-5.aspx