|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
replication error - agent is suspect
Hi,
I have set up a replication and it was doing the bulk copy from SrvA to SrvB when it says "The agent is suspect as there's no response for the last 10 mins" or something like that ? what could be the problem here ? however, after i refresh it , it keeps running though but i am unsure if the data has been successfully replicated over as the processing's running appreciate any advise tks & rdgs Hi ,
I have managed to resolve this issue by increasing the default 10 mins of agent inactivity tks & rdgs Show quoteHide quote "maxzsim" wrote: > Hi, > > I have set up a replication and it was doing the bulk copy from SrvA to > SrvB when it says "The agent is suspect as there's no response for the last > 10 mins" or something like that ? > > what could be the problem here ? > > however, after i refresh it , it keeps running though but i am unsure if the > data has been successfully replicated over as the processing's running > > appreciate any advise > > tks & rdgs Hi,
See the previous posts:- http://groups.google.co.in/group/microsoft.public.sqlserver.replication/browse_thread/thread/45cba0e7e1543879/7936c788aeacadb7?q=replication+agent+is+suspect&rnum=2&hl=en#7936c788aeacadb7 Thanks Hari SQL Server MVP Show quoteHide quote "maxzsim" <maxz***@discussions.microsoft.com> wrote in message news:13D1D8DF-E095-4F6C-9CAB-06D63015A95D@microsoft.com... > Hi, > > I have set up a replication and it was doing the bulk copy from SrvA to > SrvB when it says "The agent is suspect as there's no response for the > last > 10 mins" or something like that ? > > what could be the problem here ? > > however, after i refresh it , it keeps running though but i am unsure if > the > data has been successfully replicated over as the processing's running > > appreciate any advise > > tks & rdgs
Other interesting topics
Major Performace problem
Why the update process take so much time?? execure store procedure from Query Analizer sqlservr.exe using high I/O Combine 3 Queries into One stored procedure Commenets on Running Citrix on SQL Server? Anyone doing this? open table SQL Agent Autostart Can Triggers Help Me out |
|||||||||||||||||||||||