Post reply

Can't Delete Log Shipping Primary DB

  • January 21, 2016 at 12:11 pm

    #315140

    I have LS setup on 2014. The LS destination server has had and IP change. When I try to uncheck LS in the GUI it will not work as it is still trying to connect to the now non existent IP of the secondary server (this is in a vmCloud environment and I had to use IP's instead of server names).

    I can successfully run sp_delete_log_shipping_primary_secondary on the primary server; however, when I execute sp_delete_log_shipping_primary_database on the primary server I receive "Msg 32011 Primary Database xxx has active log shipping secondary database(s). Drop the secondary database(s) first." I have already removed LS on the secondary server.

    How do I clean this mess up as I don't want to have to restore production DB's to fix this issue?

  • January 21, 2016 at 12:14 pm

    #1853612

    Nevermind - operator error - it helps to have the correct IP in the sp_delete_log_shipping_primary_server.

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

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