Snapshot agent hanging

Last Post 26 Nov 2005 03:04 AM by Shariq. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
prospec
New Member
New Member

--
02 Oct 2005 02:19 PM
Hi,
The snapshot agent for my transactional replication package seems to be hanging or stuck on the first step. Can anyone shed any light on this issue. I've never seen this type of problem before. In the last action column it says "starting agent" but never gets passed that point.
mulhall
New Member
New Member

--
03 Oct 2005 11:34 PM
Is this the first time you've initiated replication?
Shariq
New Member
New Member

--
26 Nov 2005 03:04 AM
I have 450+ Databases on my server, I've tried to bring those databases under transactional replication. I know that there is a bug in microsoft sql server 2000 for large number of agents (you can read KB246330). each snapshot agent run on its specified time without clashing with other agents. I tried to enable replication on 100 databases in the first phase but snapshot agent starts hanging with the message 'starting agent'. this is really frustrating.
You are not authorized to post a reply.

Acceptable Use Policy