Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : Synch hangs


David
1/12/2006 1:16:50 PM
SQL2K Merge replication. When starting the synchronization it displays
"Retreiving subscription information" in the sync dialog and hangs there
forever. If I look on the server at Merge Agents, it reads "Last
Action:Connecting to Publisher <Publisher name>". Network connection to
the SQL server is good, but for some reason it can never begin the
subscription sync.

David

Hilary Cotter
1/12/2006 3:30:13 PM
I've seen hangs like this which have only being solved by rebooting the
publisher. Can you create a local subscription and try to pull it from
there. If you get the same error you need to reboot.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

AddThis Social Bookmark Button