Cannot delete transactional copy job from secondary server

Avyayah 1,211 Reputation points
2020-12-14T19:07:24.55+00:00

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.
47958-copylogship.jpg

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
    2020-12-15T06:08:56.737+00:00

    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,
    Amelia


    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