all groups > sql server replication > june 2006 >
You're in the

sql server replication

group:

How to: Restart the Distribution Agent w/ Transaction Replication


How to: Restart the Distribution Agent w/ Transaction Replication sdebriere NO[at]SPAM gmail.com
6/19/2006 6:59:40 AM
sql server replication:
I apologize for the lame question. However, I'm unable to find where in
SQL Server 2005 you can restart the Distribution Agent.

Can someone help me out by giving some direction on how to restart the
disribution agent?

Thanks Seth
Re: How to: Restart the Distribution Agent w/ Transaction Replication Hilary Cotter
6/19/2006 10:56:43 AM
You can start it in the jobs folder if you know its name. Otherwise upon up
replication monitor, expand the server tree to expand all the publications
on your publisher. Click on the problem publication and then right click on
the your subscription in the all subscriptions pane. This is your
distribution agent, select start synchronizing.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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]

Re: How to: Restart the Distribution Agent w/ Transaction Replication sdebriere NO[at]SPAM gmail.com
6/19/2006 8:10:30 PM
Money...thanks Hilary.

[quoted text, click to view]
AddThis Social Bookmark Button