Change ‘sync_method’ in publication

  • DBA-640728

    SSChampion

    Points: 12896

    hi guys i have a transactional replication with two active pull subscriptions. I am trying to change one of the parameters for my publication @sync_method = N’concurrent’, i have tried running this in the publisher:

    USE DistDB

    exec sp_changepublication @publication = ‘SynchPub’,

    @property = ‘sync_method’, @value = ‘concurrent’

    GO

    but i keep getting:

    Msg 20608, Level 16, State 1, Procedure sp_MSreinit_article, Line 190

    Cannot make the change because there are active subscriptions. Set @force_reinit_subscription to 1 to force the change and reinitialize the active subscriptions.

    I am confused because i checked my articles in my publication but they all have @force_invalidate_snapshot = 1, @force_reinit_subscription = 1

    and i reinitialized the active subscriptions but i keep getting the same error

    Can someone tell me what else is needed to make this change?

  • Chuck Hottle

    SSCarpal Tunnel

    Points: 4717

    I don’t believe that you can change this. I think that I looked into it recently and the only option seemed to be dropping and creating the publication.

  • MysteryJimbo

    SSC-Insane

    Points: 24203

    Chuck is right. You cant change this without rebuilding the publication.

  • DBA-640728

    SSChampion

    Points: 12896

    thank you guys, that’s what i did.

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

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