I would like to know steps to remove peer to peer replication from my sql server 2008. I have checked in internet i didn't find proper article for this problem. Note :- sp_removedbreplication :- Will this sp remove whole my replication setup. Also i found some command in internet. In which order we have to run this command and where we have to run? sp_dropsubscription sp_droppullsubscription sp_dropmergesubscription sp_dropmergepullsubscription sp_droppublication sp_dropmergepublication sp_replicationdboption sp_dropsubscriber sp_dropdistributor Thanks in advance.
You need to know how the topology is set up to know which command needs running on which server. Whether it is a push or pull subscription, whether you are centrally distributing or remotely. Unless you are running a huge topology, I suggest you use SSMS and the provided wizards to remove the replication.