SQL Server Performance

Add article to pub without re-snapping entire DB

Discussion in 'SQL Server 2005 Replication' started by methodology, Sep 25, 2006.

  1. methodology New Member


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


    Alastair Jones.
  2. ndinakar Member

    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

Share This Page