Concurrent snapshot processing

• Roust_m

  SSCoach

  Points: 17410

  More actions

  April 14, 2004 at 1:30 am

  #82556

  Hi!

  Found in this article, that concurrent snapshot processing allows less locks made (at the cost of time) when making a subscription.  Could not figure out how to use this option.  In GUI or using  sp_addsubscription? I need, sometimes, to subscribe another server for publication (transactional replication) during working hours.

   

  Thanks.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  April 15, 2004 at 9:42 am

  #502979

  You have the option available from the publication properties. It is a parameter of the publicacion, not the subscriptions. Wich means all subscriptions on anyone.

   

  In the sp_AddPublicacion sp in the @sync_method parameter, if you use concurrent, then the snapshot won't lock the articles part of the publication and all the transactions made during the generation of the snapshot are saved into the log and replicated once you start syncronising.