Post reply

Adding articles to replication

  • January 9, 2014 at 10:57 am

    #302425

    Hi Experts,

    I have question about adding articles in replication , as you know I have replication setup from Backup and Restore method, now I have to add more articles (tables) to it.

    Should I recreate entire replication after selecting new articles or is there any other way I can add them and it will be replicated to Subscription server?

    Thank you for your help.

  • January 10, 2014 at 12:07 am

    #1679043

    Hi

    i think it is possible to add new article to a replication without creating a new snapshot for all article:

    http://www.mssqltips.com/sqlservertip/2502/limit-snapshot-size-when-adding-new-article-to-sql-server-replication/

    regards,

    Andreas

  • January 19, 2014 at 4:42 pm

    #1681412

    You could add the articles with 'none' as the sync-type option however you will need to manually get the tables, repl procs & table data to the subscriber.

    Cheers

    Vultar

  • January 19, 2014 at 4:44 pm

    #1681414

    By the way, Is there any reason not to just add the articles and take a snapshot ?

  • January 19, 2014 at 11:43 pm

    #1681433

    Hi,

    my reason not to take a new snapshot is the size of my database. It is about 450 GB and it takes over 24 hours to create, deliver and restore the entire shapshot at the subscriber.

    If i only add one table at the publisher, i need a few seconds to create, deliver and to restore the very small snapshot at every subscriber.

    Regards,

    Andreas

  • January 20, 2014 at 5:50 pm

    #1681709

    Yes, you can add single (or few) table to existing replication via UI or script without recreating snapshot for whole DB

  • January 21, 2014 at 11:31 am

    #1682113

    Thank you so much , once I am done with this testing I will update.

Viewing 7 posts - 1 through 6 (of 6 total)

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