• use the following to purge backup files from the secondary

    exec sys.sp_change_log_shipping_secondary_primary

    @primary_server='primary sql instance'

    , @primary_database='primary db name'

    , @file_retention_period = no_of_minutes_to_keep

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

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