Re: Snapshot agent doesn't pick new articles

Hi Tesh,

I have to say that the restriction of disallowing the addition of a
subscription for a single article when the publication is configured to use
concurrent snapshot doesn't seem very valid in your scenario as that ended
up violating the spirit of the check (now you have an incomplete
subscription without the new article). That said, I have very little idea of
why the check is there in the first place and so I don't know whether we can
relax this restriction in the future or not. At the risk of getting myself
into trouble, you can circumvent the check by specifying @reserve =
'internal' when you add the subscription for the new article and the
snapshot agent should generate snapshot for the new article after that.

Hope that helps,

-Raymond

"Tesh" <Tesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:89838F59-21B0-4F2F-B2FE-6F7D2ABF75A4@xxxxxxxxxxxxxxxx
Hi Rodrigo,

Have tried your suggestion but got the following error.
Server: Msg 14058, Level 16, State 1, Procedure sp_addsubscription, Line
491
The subscription already exists.

any ideas ?

Regards


"Rodrigo" wrote:

When using concurrent snapshots, wich means that the snapshot won't lock
the
tables while generating the snapshot.

You should run
EXEC sp_addsubscription @Subscriber = 'SubscriberName', @Destination_DB =
'DB at Subscriber', @Publication = 'Name Of Publication', @Article =
'ALL'

Even that you specify 'ALL' in the articles to subscribe, SQL will
subscribe
the subscriber to the new article recently added.

Then try running the snapshot agent.
--
Rodrigo Acosta


"Tesh" wrote:

I can create a separate publication and it all works fine. I don't want
to do
this as it doesn't make sense to create a separate publication when I
want to
add an article to a publication.

"Hilary Cotter" wrote:

Sounds like this option isn't supported for concurrent snapshots. How
about
creating a separate publication for just this one article.

--
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



"Tesh" <Tesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@xxxxxxxxxxxxxxxx
Hi Hilary,
Thanks for the reply. I have run and got the following error
messages.
There
are more than one subscribers to the publication. I have used
wizard to
put
the article.


Server: Msg 14100, Level 16, State 1, Procedure sp_addsubscription,
Line
240
Specify all articles when subscribing to a publication using
concurrent
snapshot processing.


"Hilary Cotter" wrote:

How are you adding the new articles?

If you have a pull subscription you have to issue a call to
sp_refreshsubscriptions

If you have a push you have to do a call to sp_addsubscription as
follows

sp_addsubscription
'publicationmame','NameOfObjectYouJustAdded','SubscriberName'


--
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



"Tesh" <Tesh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@xxxxxxxxxxxxxxxx

Hi all,

I am running SQL Server 2000 sp4 with remote distribution
server. I
have
publications. When I adding new articles to the publications,
the
snapshot
agent doesn't pick up a new articles. When running the snapshot
agent,
it
will say snapshot was not generated because no subscription
needed
initialisation.








.

Relevant Pages

  • Re: Log wont Truncate when Publication is created
    ... deleted the publication, I first deleted the subscription. ... recreating the snapshot publication. ... database is almost completely rebuilt with each update, ...
    (microsoft.public.sqlserver.replication)
  • Re: Snapshot agent doesnt pick new articles
    ... Even that you specify 'ALL' in the articles to subscribe, ... Then try running the snapshot agent. ... this as it doesn't make sense to create a separate publication when I want to ... If you have a pull subscription you have to issue a call to ...
    (microsoft.public.sqlserver.replication)
  • Re: Replication Errors running SQL Server 2005 beta
    ... >> I should have an initial publication. ... >> sure the snapshot was created. ... The Snapshot Agent will run under the Administrator account. ... >> running SQL Server, ...
    (microsoft.public.sqlserver.ce)
  • Re: install/configure SQL Server 2000, SQL Server CE for merge rep
    ... Publication: NorthwindProducts ... PublisherDB: Northwind ... A snapshot of 1 articlewas generated. ... > check the replication monitor in SQL Server 2000 Enterprise Manager ...
    (microsoft.public.sqlserver.ce)
  • RE: Error creating new push subscription after deleting the existi
    ... To drop a push subscription to all articles for a transactional ... At the Publisher, open SQL Server Enterprise Manager, expand a server ... group, expand the Replication folder, expand the Publications folder, click ... the publication that has the subscription you want to delete, ...
    (microsoft.public.sqlserver.replication)