Showing posts with label subscribing. Show all posts
Showing posts with label subscribing. Show all posts

Thursday, February 16, 2012

change publication sync_method from native to concurrent

I have a publication defined with the default sync_method of native. I have
1 subscriber subscribing to that publication . I am adding a new subscriber
and want to subscribe to it with the concurrent option. Can I change the
publication property without affecting the existing subscriber and if so how
?
right click on your publication, select the snapshot tab, and then change it
from native to concurrent. When you deploy the new subscriber it will use
the concurrent snapshot option.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:uREvlXdrFHA.2876@.TK2MSFTNGP12.phx.gbl...
> I have a publication defined with the default sync_method of native. I
have
> 1 subscriber subscribing to that publication . I am adding a new
subscriber
> and want to subscribe to it with the concurrent option. Can I change the
> publication property without affecting the existing subscriber and if so
how
> ?
>