Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Adding articles to replication Expand / Collapse
Author
Message
Posted Thursday, January 09, 2014 10:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:35 PM
Points: 41, Visits: 672
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.
Post #1529462
Posted Friday, January 10, 2014 12:07 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 48, Visits: 257
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
Post #1529647
Posted Sunday, January 19, 2014 4:42 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:27 PM
Points: 217, Visits: 1,061
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
Post #1532473
Posted Sunday, January 19, 2014 4:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, April 11, 2014 2:27 PM
Points: 217, Visits: 1,061
By the way, Is there any reason not to just add the articles and take a snapshot ?
Post #1532475
Posted Sunday, January 19, 2014 11:43 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 2:21 AM
Points: 48, Visits: 257
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
Post #1532504
Posted Monday, January 20, 2014 5:50 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Sunday, April 20, 2014 5:18 PM
Points: 424, Visits: 1,544
Yes, you can add single (or few) table to existing replication via UI or script without recreating snapshot for whole DB
Post #1532827
Posted Tuesday, January 21, 2014 11:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 2:35 PM
Points: 41, Visits: 672
Thank you so much , once I am done with this testing I will update.
Post #1533291
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse