Prev: SQL 2008 Trans Repl Error - Never seen before?
Next: Question regarding how the witness server works.
From: Claudio on 6 May 2010 13:50
I would like to know how to add a new article (table or procedure) to the
subscriber that was initialized from a backup.

From: Ben Thul on 6 May 2010 15:19
The method for adding an article shouldn't really depend on how you
initialized it. Issuing a call to sp_addarticle will suffice. One
thing I've run across though is that the sync_method, immediate_sync,
and allow_annonymous_subscribers properties defined on the publication
affect what will happen when you generate the snapshot for the new
article. If sync_method is "snapshot", immediate_sync is false, and
allow_anonymous_subscribers is false, then the snapshot will be
generated only for your new article. If they're anything else, a
snapshot will be generated for all articles in the publication. And
that can be a real pain. Hope this helps!
--
Ben

On May 6, 12:50 pm, "Claudio" <clau...(a)expertsinfo.com.br> wrote:
> I would like to know how to add a new article (table or procedure) to the
> subscriber that was  initialized from a backup.

 | 
Pages: 1
Prev: SQL 2008 Trans Repl Error - Never seen before?
Next: Question regarding how the witness server works.