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.
Thanks
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.
]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |