SQL Server Performance

Adding one more subscriber

Discussion in 'Performance Tuning for SQL Server Replication' started by arisdxb, Oct 29, 2005.

  1. arisdxb New Member

    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
  2. ghemant Moderator

    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 />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  3. arisdxb New Member

    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

Share This Page