A snapshot was generated because there was no subscription

  • Dear All,

    I tried to re-add an article by recreating a table on the Publisher so it can also appear on the Subscriber but I get the following message after I execute the snapshot agent job "a snapshot was generated because there was no subscription" and as a result the Article does not appear on the the Subscriber side; is there anything I'm missing please?

    Thank you in advance!

  • tt-615680 - Wednesday, October 31, 2018 6:45 AM

    Dear All,

    I tried to re-add an article by recreating a table on the Publisher so it can also appear on the Subscriber but I get the following message after I execute the snapshot agent job "a snapshot was generated because there was no subscription" and as a result the Article does not appear on the the Subscriber side; is there anything I'm missing please?

    Thank you in advance!

    Did you drop the article with the table, drop the table on the subscriber and then recreate it on the publisher and add the article? That's the sequence of what you would normally do if you needed to recreate a table on the publisher that you wanted to replicate.

    Sue

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

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