Groups | Blog | Home
all groups > sql server replication > july 2006 >

sql server replication : Snapshot for new added articles


sqlprobs NO[at]SPAM gmail.com
7/20/2006 8:14:25 AM
We are using transactional replication on SQL Server 2005 SP1

When we add new article snapshot agent create a snapshot of all
articles which takes too much time but I want only snapshot of new
added article. Is it possible to create snapshot of only new added
articles and apply it at subscriber and how?
Hilary Cotter
7/20/2006 1:02:20 PM
This should be the default with transactional replication. Do you see an
entire snapshot being generated?

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

sqlprobs NO[at]SPAM gmail.com
7/20/2006 11:00:16 PM

[quoted text, click to view]

Yes, if I have published 3 articles and If I add one more article and
run snapshot agent , then at the end it shows snapshot of 4 articles
generated while it should be snapshot of 1 article generated.
AddThis Social Bookmark Button