I need a small help & suggestions on Replication. As I wanted to remove Replication completely from one of my servers. So, I did the below process to remove it. I have no idea whether it’s the right way to do or not, Please help me in doing it in a process.
I have disabled all the replication related jobs in both publication server databse side and subscriber side after that deleted the publication and subscriber manually but thats not the good way some of the replication related tables will not remove if we do that so how can we remove replication completely including distributor and belongings
we have configured the replication again and after configuring that it shows that it is excallent. but the data from publisher is not getting updated into the subscriber, i have no idea where im getting problem. i can see all the publisher, distributer and subscriber in good condition. please can you help me in finding the problem and the solution for the same.
This procedure will be done in 3 phase: 1. Remove subscriber. go to replication to select publications to select publisher and you will get the subscriber and delete them. 2. Remove publisher. go to replication to select publications to select publisher and delete. 3. Remove distributor. go server property and select replication and select 'Disable' tab this will get you a wizard and go there and disable distributor it will drop the distribution database.