Thursday, 4 July 2013

Log Shipping system tables

--Loghsipping tables for info of primary, seconday and error details

select * from msdb.dbo.log_shipping_monitor_alert

select * from msdb.dbo.log_shipping_monitor_error_detail

select * 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_primaries

select * from msdb.dbo.log_shipping_primary_databases

select * from msdb.dbo.log_shipping_primary_secondaries

select * from msdb.dbo.log_shipping_secondaries

select * from msdb.dbo.log_shipping_secondary

select * from msdb.dbo.log_shipping_secondary_databases
if you are getting threshold Alerts even after dropping database, please remove info of databases in above tables if configuration is not removed.

No comments:

Post a Comment