Post reply

reinitialize a subscription

  • June 11, 2012 at 9:41 am

    #257781

    If we reinitialize a subscription, we have to take a new snapshot.

    so this will drop the table on the subscriber and create a new one and move the data or it just refreshes the data.

  • June 11, 2012 at 9:50 am

    #1499366

    It depends on the setting. It will have been set when adding the article to the publication.

    The default is to drop and recreate the table but you can select truncate or delete as an alternative option.

  • June 11, 2012 at 10:02 am

    #1499372

    Thanks!!

    I really appreciate if you can help me to find where to check these settings?

  • June 11, 2012 at 10:48 am

    #1499390

    select sa.name, CASE sa.pre_creation_cmd WHEN 0 THEN 'None'

    WHEN 1 THEN 'Drop'

    WHEN 2 THEN 'Delete'

    WHEN 3 THEN 'Truncate'

    END

    from sysarticles sa with(nolock) where sa.name = 'Table'

    See this article.

    http://msdn.microsoft.com/en-us/library/ms174970.aspx

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

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