Post reply

Delete publication without distibution

  • January 23, 2009 at 1:35 am

    #217687

    Hello,

    i have a problem with deleting a publication. The distribution database was deleted and i can not restore it. How do I remove the "dead" publication? I get an error 18482 if I try it.

    Thanks for help.

  • January 23, 2009 at 2:34 am

    #931691

    Hi all,

    I just solved the problem. I used

    exec sp_removedbreplication @dbname = 'dbname', @type = 'tran'

    Thanks

  • January 23, 2009 at 6:45 am

    #931759

    Hi,

    In my case this command was not working ,so,i set up distributor again and then tried deleting the publisher and it worked.

    Actually while deleting publisher replication first removes all the config/info about it from distributor.So if you delete it beforehand it errors out.Substitute one distributor,it will work.

    Regards,

    Jason

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

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