Change the LogShip Monitor Server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Change the LogShip Monitor Server

Change the LogShip Monitor Server

Rate Topic

Display Mode

Topic Options

Author

Message

firthr

Posted Wednesday, November 19, 2008 6:38 AM

SSC 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 »

Permissions