• remove traces of any redundant secondary databases on the secondary server using

    USE master;

    go

    exec sp_delete_log_shipping_secondary_database

    @secondary_database = 'secondary_database';

    Once you're sure any LS scenarios have been cleared remove the alert job using

    USE master;

    GO

    EXEC sp_delete_log_shipping_alert_job;

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉