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.