how to re-run the snapshot for the newly added table in trnasactional replication

• Tushar Kanti

  Ten Centuries

  Points: 1145

  More actions

  October 7, 2009 at 8:28 am

  #98016

  I am having a confusion with the snapshot process. If I mark it for relication it re-builds all the data in tables from publisher to subscriber. Can any 1 guide me how to run the snapshot to sycn the new table added in replication.

  Thanks,

  Tushar

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  October 8, 2009 at 2:19 pm

  #1063724

  When you add the new article to the existing publisher, it will generate a snapshot for only that table. Not for the whole publisher.

  -Roy