SQL Server Performance

Failed Log Shipping Monitor Server

Discussion in 'SQL Server Log Shipping' started by jrofarrell, Aug 1, 2005.

  1. jrofarrell New Member

    Dose any one have any ideas how I can remove log-shipping without the monitor server in place?


  2. satya Moderator

    To remove log shipping from a database maintenance plan, open the plan's Properties dialog box, go to the Log Shipping tab, then click Remove Log Shipping.

    Deleting the database maintenance plan removes that job. To remove the Log Shipping Monitor from the monitor server, manually delete the applicable rows from the log_shipping_primaries and log_shipping_secondaries tables in the monitor server's msdb database.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page