November 19, 2008 at 6:38 am
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
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply