Post reply

Adding an Artcle to an exiting publication need Snapshot agent to run?

  • July 18, 2017 at 1:37 pm

    #402323

    Hi

    After adding an article to an existing publication if the snapshot agent is run which will apply and resync against all articles part of the publication process? or does it only applies / sync the data / schema/index against that specific particle alone to all the subscribers?

    Thanks.

  • July 19, 2017 at 8:18 am

    #1951645

    SQL-DBA-01 - Tuesday, July 18, 2017 1:37 PM

    Hi

    After adding an article to an existing publication if the snapshot agent is run which will apply and resync against all articles part of the publication process? or does it only applies / sync the data / schema/index against that specific particle alone to all the subscribers?

    It depends. By default it will generate a snapshot for all articles in the publication. If you disable the publication options immediate_sync and allow_anonymous then it will generate a snapshot for the new article only. Those are both enabled by default when you create the publication.
    If you want to change these settings, you can use something like the following:

    --Run publisher database to get name of publication
    sp_helppublication

    --Run on your publisher database to change the options
    EXEC sp_changepublication
    @publication = 'YourPublicationName',
    @property = 'allow_anonymous' ,
    @value = 'false'

    EXEC sp_changepublication
    @publication = 'YourPublicationName',
    @property = 'immediate_sync' ,
    @value = 'false'

    Sue

  • July 19, 2017 at 8:37 am

    #1951654

    I can see that the "Allow Anonymous Subscription" and Allow Immediate Updating Subscriptions are False in the GUI I can.

    Is that what you are saying to be disabled, Sue?

    Thanks.

  • July 19, 2017 at 8:46 am

    #1951658

    SQL-DBA-01 - Wednesday, July 19, 2017 8:37 AM

    I can see that the "Allow Anonymous Subscription" and Allow Immediate Updating Subscriptions are False in the GUI I can.

    Is that what you are saying to be disabled, Sue?

    There was a blog about this recently -

    http://www.sqlservercentral.com/blogs/sql-geek/2017/07/

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • July 19, 2017 at 8:53 am

    #1951661

    Nice one. thnx

    Thanks.

Viewing 5 posts - 1 through 4 (of 4 total)

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