Remove article from existing publication, does it require a new snapshot?

  • indinfo2011

    SSC Eights!

    Points: 833

    Starting the snapshot agent re snapshots all the time. I don't want the new snapshot. It should just sync the data where it was left off.

    Why do I get this message every week? This is not even the error as I don't receive the emails up on failures.

    Any idea?

  • indinfo2011

    SSC Eights!

    Points: 833

    How do I manually start the snapshot agent?

  • Mohammad Asaf

    Newbie

    Points: 9

    When I have subscription to the article and try to drop the article;

    DECLARE @publication AS sysname;
    DECLARE @article AS sysname;
    SET @publication = N'MiscREGI';
    SET @article = N'Classification';
    -- Drop the transactional article.
    EXEC sp_droparticle
      @publication = @publication,
      @article = @article,
      @force_invalidate_snapshot = 1;
    GO

     I get the following error;

    Msg 14046, Level 16, State 1, Procedure sys.sp_MSrepl_droparticle, Line 286 [Batch Start Line 29]
    Could not drop article. A subscription exists on it.

    It requires dropping the subscription first;
    EXEC sp_dropsubscription @publication = 'ClassificationPublication-Crescent', @article = 'Classification', @subscriber = 'CBTDEVSQL01\DEV', @destination_db = 'DecisionLenderReporting'

Viewing 3 posts - 46 through 48 (of 48 total)

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