Post reply

Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

  • April 24, 2013 at 10:53 pm

    #271862

    Hi Experts

    I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs are running still I can not drop the Publication. Please help

    Screen Short Attached of the problem

    Thanks

  • April 25, 2013 at 1:19 pm

    #1610104

    try this..

    sp_droppublication @publication='publicationName', @ignore_distributor = 1

  • April 25, 2013 at 1:32 pm

    #1610107

    Giving error

    Can not drop the Publication because at least one Subscription exists for this Publication.

    Drop all Subscription to the Publication before attempting to drop the Publication.

    Now I am getting this error . I never made any Subscription on my Subscription database.

  • April 25, 2013 at 1:38 pm

    #1610108

    Check under replication "Local Subscription"? Is there any?

  • April 25, 2013 at 1:47 pm

    #1610113

    No there is no Subscriptions there

  • April 25, 2013 at 1:56 pm

    #1610117

    Do you see anything under Local Publication then Publication and click on + of publication..If yes try the below mentioned command..

    USE master

    EXEC sp_removedbreplication @dbname='DBName'

    GO

    sp_dropsubscription @subscriber='SubscriptionName'-- If you find anything under +

    sp_droppublication 'PublicationName'

  • April 25, 2013 at 2:17 pm

    #1610128

    So I was able to remove the replication that command went fine, but there is no subscription & Publication is still there.

  • April 25, 2013 at 2:22 pm

    #1610129

    Glad it worked for you.

  • April 25, 2013 at 2:30 pm

    #1610132

    Thanks A lot

Viewing 9 posts - 1 through 8 (of 8 total)

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