Cannot delete transactional copy job from secondary server

Avyayah 1,211 Reputation points

Implemented logshipping in primary server and logs are backed up in the primary server. They are also getting copied to secondary server and I have scheduled to delete from secondary server after 4 hrs but none of the transactional logs are deleted.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,654 questions
0 comments No comments
{count} votes

Accepted answer
  1. AmeliaGu-MSFT 13,961 Reputation points Microsoft Vendor

    Hi @Avyayah ,

    Could you please check there are any error messages in error log? Please make sure the restore job is working fine.
    And you can try to disable the 3 log shipping jobs and take a differential backup of the primary and apply it to the secondary. Then clean all backup files from the secondary location, and re-enable the 3 jobs.
    Please refer to this thread which might help.

    Best Regards,

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful