If you have Transaction Log Shipping configured at your environment and one of the servers or databases fails then there is no way to remove Log Shipping using the GUI. The only way to clear the Log Shipping is using T-SQL script.
There are three steps in total that needs to be run to remove the Log Shipping from the Primary and from the Secondary database. If the Secondary server is completely lost just run Step 1 & 2 to clean the Log Shipping.
Step 1. Run this to the Primary server. It cleans all information about the secondary database.
EXEC master.dbo.sp_delete_log_shipping_primary_secondary @primary_database = N'primarydatabase', @secondary_server = N'primaryserver', @secondary_database = N'secondarydatabase' GO
Step 2. Run this to the Primary server. It cleans the Log Shipping configuration from the Primary server & the SQL Agent backup job.
EXEC master.dbo.sp_delete_log_shipping_primary_database @database = N'primarydatabase'; GO
Step 3. Run this to the Secondary server. It cleans the Log Shipping from the Secondary database
EXEC master.dbo.sp_delete_log_shipping_secondary_database @secondary_database = N'secondarydatabase' GO
Pantelis Apostolidis is a Sr. Specialist, Azure at Microsoft and a former Microsoft Azure MVP. For the last 20 years, Pantelis has been involved to major cloud projects in Greece and abroad, helping companies to adopt and deploy cloud technologies, driving business value. He is entitled to a lot of Microsoft Expert Certifications, demonstrating his proven experience in delivering high quality solutions. He is an author, blogger and he is acting as a spokesperson for conferences, workshops and webinars. He is also an active member of several communities as a moderator in azureheads.gr and autoexec.gr. Follow him on Twitter @papostolidis.
