Hi
I am looking for a way to avoid the option of 'Yes initialize the Schema and
the data' (which I suspect is the source of some problems) when I create a
new subscription
Thank you,
Samuel
Its no problem to do this with named subscriptions in merge replication.
Anonymous requires a snapshot.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
news:%23768oty4GHA.1460@.TK2MSFTNGP05.phx.gbl...
> Hi
> I am looking for a way to avoid the option of 'Yes initialize the Schema
> and the data' (which I suspect is the source of some problems) when I
> create a new subscription
> Thank you,
> Samuel
>
>
|||How can I cheese a Named Subscription?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23owZLBz4GHA.3600@.TK2MSFTNGP03.phx.gbl...
> Its no problem to do this with named subscriptions in merge replication.
> Anonymous requires a snapshot.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Samuel Shulman" <samuel.shulman@.ntlworld.com> wrote in message
> news:%23768oty4GHA.1460@.TK2MSFTNGP05.phx.gbl...
>
|||What you are referring to is a nosync initialization. I have a couple of
articles on this that will hopefully help a bit:
http://www.replicationanswers.com/No...alizations.asp
http://www.replicationanswers.com/NoSyncOn2005.asp
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
No comments:
Post a Comment