| Author |
Topic |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-02-21 : 07:19:55
|
| Hi Experts,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 Thank you In Advance. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-21 : 14:57:46
|
| Thank you Kizer |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-22 : 09:16:06
|
| Hi Kizer,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. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-22 : 12:36:54
|
| Did you run the snapshot agent? |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-22 : 12:59:22
|
| Hi Russell,Yes i did and we configured the transactional replication. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-22 : 13:59:18
|
| What's the status of the log reader agent?Try inserting a tracer token. |
|
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-22 : 15:43:15
|
| it was running fine and shows the connection is excallent for all |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-02-22 : 16:17:29
|
| Did you insert a tracer token? |
|
|
|
pollostar
Starting Member
3 Posts |
Posted - 2012-03-15 : 08:47:06
|
| 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. |
|
|
|
|
Removing Replication