Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Replication (2005)
 No agent status information is available.

Author  Topic 

danyeung
Posting Yak Master

102 Posts

Posted - 2009-05-13 : 13:54:11
I created the publictaion in SQL2000 and the subscription in SQL2005. When I right clicked on the SQL2000 publication and clicked the Start button in View Synchronization Status, it started for few seconds and stopped. The last status message was "No agent status information is available." It had been working for about 2 years and stopped working recently. Any idea?

Thanks.
DanYeung

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-05-13 : 17:07:49
Check replication monitor for why it is no longer working.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

"Let's begin with the premise that everything you've done up until this point is wrong."
Go to Top of Page

danyeung
Posting Yak Master

102 Posts

Posted - 2009-05-14 : 11:36:58
Replication monitor shows it is no running. How do I find out why?

Thanks.
DanYeung
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-05-14 : 23:32:33
What does job history for replication say(Error)?
Go to Top of Page
   

- Advertisement -