SQL Server Performance Forum – Threads Archive

Adding one more subscriber

Hi All I have a transactional replication with one publisher/distributor and one subscriber. I want to add one more subscriber for another location. What is the best method to add one more subscriber? Expect expert’s suggestions. Regards,
Aris

---

Hi,<br /><br />read <b>sp_addsubsriber</b> in BOL for more information ..<br /><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />

---

Thanks But the replication is already running and I want add one more subscriber to it. Do I need to create initial snapshot again for new subscriber? There is any document available for more information. Aris

---

]]>