Discussion:
Replication Jobs listed after disabling/removing replication
(too old to reply)
war
2010-12-27 14:32:21 UTC
Permalink
I'm running SQL Server 2000 and have used replication for many years.
For one reason or the other, I've needed to enable and/or disable
replication completely between three servers.

Scenario - I've disabled replication completely yet there are still
several REPL jobs appearing in the JOBs list. HOW CAN I DISABLE
REPLICATION COMPLETELY INCLUDING REMOVING THESE JOBS? I want to
recreate replication without any artifacts for the past.

Lastly, after disabling replication can I simply delete these jobs?
Ben Thul
2010-12-27 16:52:59 UTC
Permalink
You want sp_removedbreplication. That's pretty much the biggest
hammer you can wield here. As to your question regarding the agent
jobs, they can be safely removed. You can even remove them while you
have a live topology; methods exist to easily get them back (e.g.
sp_addlogreader_agent). Of course, you would be missing the
functionality that they provide while they're not running, but it
doesn't break anything irrevocably.
--
HTH,
Ben
Post by war
I'm running SQL Server 2000 and have used replication for many years.
For one reason or the other, I've needed to enable and/or  disable
replication completely between three servers.
Scenario - I've disabled replication completely yet there are still
several REPL jobs appearing in the JOBs list.  HOW CAN I DISABLE
REPLICATION COMPLETELY INCLUDING REMOVING THESE JOBS?  I want to
recreate replication without any artifacts for the past.
Lastly, after disabling replication can I simply delete these jobs?
Loading...