Deleting Log Shipping
Posted on 2011-03-17
Hi. ServerA (2005) was log-shipping to ServerB to have a warm failover.
However, ServerB has completely bitten the dust and is with us no longer. ServerA, however, is not easily letting go of this log-shipping relationship.
Going into the GUI DB Properties of ServerA allows me to turn it off--theoretically--but the subsequent dialog after disabling log-shipping never ends. I think it's still waiting to hear from ServerB, who ain't never coming home.
I think I've killed the LS jobs in Agent.
How do I, as gracefully as possible, end this relationship? End log-shipping for certain databases on ServerA?