Change the LogShip Monitor Server

• firthr

  SSCommitted

  Points: 1606

  More actions

  November 19, 2008 at 6:38 am

  #154928

  Anyone know how you maintain log shipping and just change the server that monitors the latency, copy etc. Our monitor server is beign decomissioned so we need to swap to another. From the GUI the monitor is not not configurable. I think you might have to hack the tables but I don't know which ones, none of these seem candidates:

  SELECT * FROM msdb.dbo.log_shipping_monitor_alert

  SELECT * FROM msdb.dbo.log_shipping_monitor_error_detail

  SELECT TOP 100 * FROM msdb.dbo.log_shipping_monitor_history_detail

  SELECT * FROM msdb.dbo.log_shipping_monitor_primary

  SELECT * FROM msdb.dbo.log_shipping_monitor_secondary

  SELECT * FROM msdb.dbo.log_shipping_primary_databases

  SELECT * FROM msdb.dbo.log_shipping_primary_secondaries

  SELECT * FROM msdb.dbo.log_shipping_secondary

  SELECT * FROM msdb.dbo.log_shipping_secondary_databases

  SELECT * FROM msdb.dbo.log_shipping_primaries

  SELECT * FROM msdb.dbo.log_shipping_secondaries