Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Change the LogShip Monitor Server Expand / Collapse
Posted Wednesday, November 19, 2008 6:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, September 27, 2010 8:38 AM
Points: 236, Visits: 99
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

Post #605092
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse