Failed Log Shipping Monitor Server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Failed Log Shipping Monitor Server

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

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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>