Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

When I look in the Replication Monitor, I see that my Log Reader Agent is not running. I right click on a publication, and click 'View Log Reader Agent Status' and it says "The proces was successfully stopped"

If i press Start, i get the following message.... It's possible i could of deleted the job 'NAVISIONUPGRADE-Navision4-1' by mistake yesterday... How can i re-create it / what does it do?

TITLE: View Log Reader Agent Status
------------------------------

The agent could not be started.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=CantStartAgent&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The specified @job_name ('NAVISIONUPGRADE-Navision4-1') does not exist. (Microsoft SQL Server, Error: 14262)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=14262&LinkId=20476
share|improve this question
    
do you have any publications setup? are your subscribers getting updates? which sever is running the distribution database? –  Nick Kavadias Dec 4 '09 at 12:52
    
yes, there are 3 publications. the subscribers are not getting updates. the subscriber is the distributor as far as i'm aware. –  alex Dec 4 '09 at 13:03
add comment

1 Answer 1

up vote 0 down vote accepted

I ended up deleted and then re-creating the publication.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.