I'm facing a rather strange issue with Transaction Log Shipping reports in SSMS which is showing multiple red alerts of databases that have been created and deleted while performing multiple Log Shipping scenario between two servers.
I've used the following post:Remove the log shipping configuration on the secondary server, when the primary is no longer available to help clear those alerts but nothing came out of this with success. Sometimes i'm getting the following error:
Msg 32011, Level 16, State 1, Procedure sp_delete_log_shipping_primary_database, Line 51 Primary Database MyFirstDB has active log shipping secondary database(s). Drop the secondary database(s) first
Which is not true as the database is already deleted on both primary and secondary server as well as three log shipping jobs.
I have more than forty orphaned databases in this state. this is saturating SQL server log with the below error for all aforementioned databases:
Date 19/08/2017 08:30:00 Log SQL Server (Archive #3 - 19/08/2017 08:31:00)
Source spid53
Message
The log shipping secondary database SQLTEST.MyFirstDB has restore threshold of 30 minutes and is out of sync. No restore was performed for 449177 minutes. Restored latency is 2 minutes. Check agent
Can you help please, clear these entries from wherever system database/tables holds these records.?
I really appreciate the help!