1

While testing SQL Server Replication we setup Replication on our ERP Test DB from SQL Server Enterprise to SQL Server Standard.

We have since got replication up-and-running on our Live database and we no longer need replication on the Test database...

We would like to PROPERLY remove the replication to free up resources and delete the Test Replicated DB.

I have read online about issues with not properly 'disassembling' or shutting down Replication but I have not been able to find a step by step on how to do it.

I just have one test DB that is replicating between these servers that I need to shutdown and remove completely.

Specifics:

SQL 2012, 1 DB, Transactional Replication.

1

To properly clean up replication, follow below steps :

  1. Open SSMS --> Local Publications --> Expand Publication -->

    enter image description here

    enter image description here

    1. Use sp_removedbreplication to remove replication bit set on database.

Another Method is script our the DROP or disable the components by right click on publication and then run that script using SSMS.

enter image description here

| improve this answer | |
  • Thanks! I ran those steps but do I need to delete the empty Publication node? Also, my Replication Monitor has an error on the Test DB Log Reader... obviously. This makes me think there is more to this. – Rick Bird Oct 26 '15 at 17:44

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.