I generated snapshot for transactional replication. During bulk coping I have
got the error for the distribution agent "Agent suspect. No responce during
10 min". What shall I do to continue the process?

I found out that it was not enough place on the drive on the subscriber.
sp_who2 on the subscriber is showing Rollback bulk insert. Is there any hope
to restart the process after rollback?
"Elena" wrote:

No, Expand Replication Monitor, expand the publications folder, right click
on your publisher and select Refresh Rate and Settings, in the inactivity
threshold bump up the setting to something large - I have set it as high as
a day. Also set KeepAliveMessageInterval to something large.
--
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

"Elena" <Elena (AT) discussions (DOT) microsoft.com> wrote

No, Expand Replication Monitor, expand the publications folder, right click
on your publisher and select Refresh Rate and Settings, in the inactivity
threshold bump up the setting to something large - I have set it as high as
a day. Also set KeepAliveMessageInterval to something large.
--
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

"Elena" <Elena (AT) discussions (DOT) microsoft.com> wrote