Post reply

created Subscription not lsited under local Subscription menu

  • February 6, 2014 at 7:30 am

    #287989

    Hello ,

    Here i am trying to setup a Transactional Replication in my local environment . proposed structure is

    Server 1 - > Distributor and publication

    Server 2 - > Subscription

    i have successfully created Distributor and publication on server one .

    When i am trying to create a Subscription on second server (Push) i can able to create it . but it is not listing . i can not see the created Subscription on "local Subscription " Menu . I will get "Subscription already exist" Error if

    i try to create it again .

    i can create this after deleting Subscription using execute sp_dropsubscription , sp_subscription_cleanup .

    concern is newly created Subscription not listed . Please help me to resolve this .

    Thanks

    Vivek Kannan

  • February 6, 2014 at 8:29 am

    #1686636

    On your publisher execute sp_helpsubscriberinfo with your new subscriber and publisher. If it is listed there then make sure that you have refreshed the "Local Subscriptions" folder on the Subscriber.


    Microsoft Certified Master - SQL Server 2008
    Follow me on twitter: @keith_tate

    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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