Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 merge replication hanging

Author  Topic 

cat_millenium
Starting Member

2 Posts

Posted - 2007-03-29 : 12:06:02
Hi all,
I have a replication that worked for a couple of weeks without any problem. Since yesterday it is hanging. I am not aware of any changes done to the network or dataservers.
Dataservers are on 2005 SP1.
In the Replication monitor I see that the replication agent gets a 10 Minutes no activity seen message.
Therefor I started the merge process manually with Outputverboselevel 2.
It is hanging again, the outputfile tells me that sp_MSadd_merge_history90 is executed.
How to resolve this issue?

dalexa1507
Starting Member

5 Posts

Posted - 2007-05-04 : 14:49:01
I have the same problem..did you find a fix ?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-04 : 22:34:38
Did you see any error message in logs?
Go to Top of Page

MohammedU
Posting Yak Master

145 Posts

Posted - 2007-05-06 : 14:52:04
Run the sql profile/trace to see what is happening...
Are you able to connect to distination server using query window...
Check if there are any blocking going on...

http://msdn2.microsoft.com/en-us/library/ms151869.aspx


MohammedU
Go to Top of Page
   

- Advertisement -