question

Mohamed4053 avatar image
Mohamed4053 asked

Peer to peer replication

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.
sql-server-2008replication
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.