SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Replication (2008)
 Removing Replication
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ksr39
Posting Yak Master

India
181 Posts

Posted - 02/21/2012 :  07:19:55  Show Profile  Reply with Quote
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

USA
37129 Posts

Posted - 02/21/2012 :  09:35:29  Show Profile  Visit tkizer's Homepage  Reply with Quote
Try sp_removedbreplication for each publisher database. For the distributor, use sp_dropdistributor.

See this if that doesn't help: http://support.microsoft.com/kb/324401

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ksr39
Posting Yak Master

India
181 Posts

Posted - 02/21/2012 :  14:57:46  Show Profile  Reply with Quote
Thank you Kizer
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37129 Posts

Posted - 02/21/2012 :  15:16:53  Show Profile  Visit tkizer's Homepage  Reply with Quote
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

ksr39
Posting Yak Master

India
181 Posts

Posted - 02/22/2012 :  09:16:06  Show Profile  Reply with Quote
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.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 02/22/2012 :  12:36:54  Show Profile  Visit russell's Homepage  Reply with Quote
Did you run the snapshot agent?
Go to Top of Page

ksr39
Posting Yak Master

India
181 Posts

Posted - 02/22/2012 :  12:59:22  Show Profile  Reply with Quote
Hi Russell,
Yes i did and we configured the transactional replication.
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 02/22/2012 :  13:59:18  Show Profile  Visit russell's Homepage  Reply with Quote
What's the status of the log reader agent?

Try inserting a tracer token.
Go to Top of Page

ksr39
Posting Yak Master

India
181 Posts

Posted - 02/22/2012 :  15:43:15  Show Profile  Reply with Quote
it was running fine and shows the connection is excallent for all
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 02/22/2012 :  16:17:29  Show Profile  Visit russell's Homepage  Reply with Quote
Did you insert a tracer token?
Go to Top of Page

pollostar
Starting Member

India
3 Posts

Posted - 03/15/2012 :  08:47:06  Show Profile  Reply with Quote
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.


Edited by - tkizer on 09/30/2012 22:10:54
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000