Adding one more subscriber | SQL Server Performance Forums

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,

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