On Primary :
delete from msdb..log_shipping_monitor_secondary
where secondary_database = '' -- secondary db name goes here
delete from dbo.log_shipping_secondary
where primary_database='' -- primary db name goes here
On Secondary:
delete from msdb..log_shipping_monitor_primary
where primary_database='' -- primary db name goes here
delete from dbo.log_shipping_primary_secondaries
where secondary_database='' -- secondary db name goes here
这通常发生在未彻底删除日志传送时。要删除孤立条目，您必须将它们从 msdb 日志传送表中删除。