|
|
You're in the
sql server replication
group:Snapshot agent doesn't pick new articles
sql server replication:
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 [quoted text, click to view] "Tesh" <Tesh@discussions.microsoft.com> wrote in message news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... > > 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.
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
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. [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... > > > > 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. > >
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 [quoted text, click to view] "Tesh" <Tesh@discussions.microsoft.com> wrote in message news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@microsoft.com... > 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@discussions.microsoft.com> wrote in message >> news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... >> > >> > 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. >> >> >>
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. [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@microsoft.com... > > 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@discussions.microsoft.com> wrote in message > >> news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... > >> > > >> > 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. > >> > >> > >> > >
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 [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > > news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@microsoft.com... > > > 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@discussions.microsoft.com> wrote in message > > >> news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... > > >> > > > >> > 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. > > >> > > >> > > >> > > > >
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 [quoted text, click to view] "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@discussions.microsoft.com> wrote in message > > > news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@microsoft.com... > > > > 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@discussions.microsoft.com> wrote in message > > > >> news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... > > > >> > > > > >> > 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. > > > >> > > > >> > > > >> > > > > > >
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 [quoted text, click to view] "Tesh" <Tesh@discussions.microsoft.com> wrote in message news:89838F59-21B0-4F2F-B2FE-6F7D2ABF75A4@microsoft.com... > 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@discussions.microsoft.com> wrote in message >> > > news:12D5C214-6DE1-4A9B-B381-C1D0434A00AF@microsoft.com... >> > > > 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@discussions.microsoft.com> wrote in message >> > > >> news:DBBBC665-B8B2-4AE1-830E-BFC525147D2E@microsoft.com... >> > > >> > >> > > >> > 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. >> > > >> >> > > >> >> > > >> >> > > >> > > >> > >
Don't see what you're looking for? Try a search.
|
April 2003
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |