May 27, 2008 at 8:25 am
Hi!
I ones had transactions between 2 local databases on the same sql-instans. Now I have noticed that I got a error message every 20 sec seing:
"Error: 14151, Severity: 18, State: 1
Replication-Replication Distribution Subsystem: agent ‘agent-name’ failed. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated."
the error is talking about subscriptions and publications that I have deleted.
I found the publications in the system table distribution..MSsubscriptions. I delete the rows, but now I got a new message in event viewer ever 20 sec:
"Replication-Replication Transaction-Log Reader Subsystem: agent ‘agent-name’ failed. The process could not execute 'sp_repldone/sp_replcounters' on ‘server-name’.
Please help me! I'm stuck...
/David
May 28, 2008 at 9:37 am
I looked in the jobs, and find all deleted replications there. I deleted the jobs, and restarted the SQL Server Agent and the the logging disappeared.
Problem solved 😀
May 28, 2008 at 10:44 am
Thanks for the update. When you delete replication, need to be sure the jobs are removed as well.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply