November 11, 2008 at 12:14 pm
Hi,
I had an replication on MS SQL 2005 server going. It did not work as it should, and I had major problem deleting it.
It is now out of the publication list and it seems like it has gone.
I have other replication going on this server and they work just fine.
I have got this in the event log.
Replication-Replication Transaction-Log Reader Subsystem: agent .
Does anyone out there have an clue on what can be wrong here?
November 11, 2008 at 1:13 pm
What does the entire of the event log entry read?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 11, 2008 at 2:57 pm
Make sure all replication Jobs in SQL Agent belonging to that publication are gone.
* Noel
November 11, 2008 at 11:48 pm
They are all gone. But, when I check the replication Monitor it shows there with an error.
How can I delete it form there?
November 11, 2008 at 11:52 pm
this is the error msg in the event log from yesterday.
Replication-Replication Transaction-Log Reader Subsystem: agent DNEPR-msdbcergobs-14 failed. The process could not execute 'sp_MSpub_adjust_identity' on 'DNEPR'.
After I got this I deleted the job and then this msg has gone. But as you can see from other posts I get the job in Replication monitor and from there I don't know how to delete it.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply