Certain errors, modification of a publication/article properties, some
schema changes, adding or removing an article. Note that the
force_invalidate_snapshot and force_reinit_subscription switches will tell
you if the change will require a snapshot.
Note that for most errors you will be able to upload changes which occur on
the subscriber before the snapshot is applied which will minimize data loss.
--
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 [quoted text, click to view] "JBs" <JBs.2cp1m0@no-mx.forums.yourdomain.com.au> wrote in message
news:JBs.2cp1m0@no-mx.forums.yourdomain.com.au...
>
> Hello,
>
> I'm using SQL Server for Merge replication and I looking for a list of
> actions that require to delete a subsription and to recreate it.
> Deleting a sub. implies to stop the production and some money loss :(
>
> For example, when modifying a publication table's structure (like
> adding a column) or changing a publication rule (addinng a filter) does
> imply to delete/recreate the sub.? Are there other actions concerned by
> the same thing? I walked through many Internet publications and
> article, especially on the MS.com website but I couldn't find anything
> anwering my questions :(
>
> In the same way (maybe someone as already done that), is there a way to
> automatize subsciptions deletions/recreation attached to a server that
> should be replicated so that downtime time is reduced to its maximum?
>
> Thanks for you help on that topic.
>
>
> --
> JBs
> ------------------------------------------------------------------------
> JBs's Profile:
http://www.dbtalk.net/m684 > View this thread:
http://www.dbtalk.net/t326446 >
