Post reply

Adding Articles to a Publication when Initializing a subscription with a backup option is used

  • October 3, 2008 at 3:11 pm

    #194376

    Initialize with backup option works fine but I have a question on functionality.

    Once my Replication is working fine can I add new articles to publication?

    If I add articles using sp_addarticle and mark for Reinitialization is set will the new articles snapshot is generated and deliver it to subscriber?

    Pat...

  • October 6, 2008 at 1:20 pm

    #881299

    Hi Pat,

    Most of my experience with this is in MS SQL 2000 but it should be almost the same.

    Its not that simple. To add new articles to your publication you will have to quiesce the database, or wait until a quiet time. Manually populate the new subscriber tables with your new articles (SSIS pkg or scripts), then drop the subscription, add the articles to the publication, and re-create the subscription. You may also need to refresh the replication stored procedures afterwards.

    Chris.

    Chris.

  • October 6, 2008 at 1:22 pm

    #881300

    One more thing.

    If you re-initialize, I'm pretty sure that means that the publisher will generate an entirely new snapshot and apply it to the subscriber. (Not just the added articles)

    Chris.

    Chris.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply