SQL Server Performance Forum – Threads Archive

Add article to pub without re-snapping entire DB

hi I simply want to add an article to an existing publication WITHOUT creating a new snapshot of the entire database, but rather just a snapshot of the new items. I can add the article just fine either through the EM or sp_addarticle, but when I come to start the snapshot agent, it copies out the enitre DB. This DB is 150GB and the subscriber is in France (im in UK) so im going to be old(er) and grey(er) by the time the snapshot is copied over. how do I accomplish this simple, yet seemingly utterly impossible task (as I have been looking and posting all over the place.) Thanks Alastair Jones.

---

Here’s a script that I use for SQL2k. you might need to modify your parameters. Also check out BOL for the mentioned stored procs to see if the parameters have changed in 2005.
————-
exec sp_addarticle @publication = ‘Pub_Name’
, @article = ‘Article_Name’
, @source_table = ‘Article_Name’
exec sp_addsubscription @publication = ‘Pub_Name’
, @article = ‘Article_Name’
, @subscriber = ‘subscriber_name’
, @destination_db = ‘subscriber_db’ ***********************
Dinakar Nethi
SQL Server MVP
***********************

---

]]>