Removing replication

Question

I want to remove replication as we are not going to use it further. I want to know what steps should we follow to remove the replication like:

1. Which jobs to stop
2. Delete subscription and publisher

...and any other things to consider. I am doing it for the first time, so I need help regarding this.

Answer 1

If I understand correctly you want to totally remove replication from the server.

There are a number of tools you can use, as outlined here for limited dismantling of replication.

Removing Replication

If you just want to strip all replication from the server, you can apparently use sp_removedreplication on each database that needs to have replication dropped.

sp_removedbreplication (Transact-SQL) on the appropriate database

The code is simple. Here is the MSDN example code:

-- Remove replication objects from the subscription database on MYSUB.
DECLARE @subscriptionDB AS sysname
SET @subscriptionDB = N'AdventureWorks2008R2Replica'

-- Remove replication objects from a subscription database (if necessary).
USE master
EXEC sp_removedbreplication @subscriptionDB
GO