After log shipping after how many days or hours we can remove the Log Backups & Backup history? | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
After log shipping after how many days or hours we can remove the Log Backups & Backup history?Dear All, I have implemented the Log shipping manually on my servers & the same is running without any error. I have a question related to LOG backup files & backup history i.e. after how many days or hours we can remove the LOG backup files (OLD ones) those are generated for copying data from Primary to Secondary server AND Backup & related history by executing "sp_delete_backuphistory" store procedure. If we do the same then is there any reverse effect on Log Shipping process? Also tell me the precautions / guideline those are to be taken in Log Shipping whether on Server or on DB level? Kindly guide me.
There is no rule for that.
My suggestion is: use your own criteria.
Managing the old backup files is an outside of Log shipping process, so in this case if you depend upon the Maintenance plans then you have an automated way on PRIMARY server but not on secondary server.
In any case you have to keep additional step as Log shipping maintenance by deleting backup files older than < days. However your other question about whether it affects log shipping or not, it will not affect it at all.