Prev: Tx Replication Issue - Syntax error, permission violation
Next: Replication agents are idles
From: Ben Thul on 1 Mar 2010 11:07
Last Friday, a request came to add two new articles to our
transactional replication setup. I did things as I normally do (i.e.
sp_addarticle & sp_addsubscription for each article, then generate
snapshot), but the subscriber would not pick up the snapshot. Here's
some information that seems relevant:

- The publication is set with the following options:
* sync_method = "database snapshot"
* immediate_sync = false
* allow_anonymous = false
- sp_addarticle was called with @schema_option = 0x000000000803509F
(have used this in the past to add articles successfully)
- Snapshot agent successfully generated a snapshot for the two
articles
- That the snapshot was generated is recorded in MSrepl_commands
- The subscription is a push subscription

I can reproduce the issue in our test environment and have the ability
to try different things there based on any suggestions that come from
this thread. Thanks in advance
--
Ben
 | 
Pages: 1
Prev: Tx Replication Issue - Syntax error, permission violation
Next: Replication agents are idles