April 14, 2004 at 1:30 am
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.
April 15, 2004 at 9:42 am
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.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply