Share via

Log shipping log backups

Chaitanya Kiran 841 Reputation points
2021-09-20T05:00:31.21+00:00

Good Morning

In Log shipping, we set up automated log backups. So, my doubt is whether these log backups truncate log file?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments

Answer accepted by question author

AmeliaGu-MSFT 14,011 Reputation points Microsoft External Staff
2021-09-20T07:00:15.057+00:00

Hi ChaitanyaKiran-2787,

Log Shipping Backup does just like regular log backup. It will delete inactive virtual log files (VLFs) from the logical transaction log of a SQL Server database, freeing space in the logical log for reuse by the Physical transaction log.
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.

Was this answer helpful?

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,616 Reputation points
    2021-09-20T06:46:48.21+00:00

    log backups truncate log file?

    Log backup don't truncate anything, it just free's VLF = Virtual log files.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.