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.
| Author |
Topic |
|
ias0nas
Starting Member
36 Posts |
 Posted - 2011-02-21 : 10:25:52
|
Hello,
Over the weekend I started getting this error message in the event logs of the DB server:
Replication-Replication Distribution Subsystem: agent (null) failed. The publication '<publication name>' does not exist.
When I run sp_readerrorlog I get this message:
Error: 14151, Severity: 18, State: 1
Replication-Replication Distribution Subsystem: agent (null) failed. The publication '<publication name>' does not exist.
The server is used as a publisher as well. I have deleted this specific publication and all the others and only left one that cannot be deleted as it is used for production.
I still get the message...
Executing this SELECT * FROM dbo.MSsubscriptions on the distribution database I only get the entries for the remaining replication that should be there.
Any ideas..? Any places I could look to delete entries for that publication?
Thanks,
Jason |
|
|
|
|
|
Error: 14151, Severity: 18, State: 1