SQL Server Performance

After log shipping after how many days or hours we can remove the Log Backups & Backup history?

Discussion in 'SQL Server 2008 Log Shipping' started by bsethi24, Nov 20, 2011.

  1. bsethi24 New Member

    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
    bsethi24, Nov 20, 2011
    #1

  2. Luis Martin Moderator

    There is no rule for that.
    My suggestion is: use your own criteria.
    Luis Martin, Nov 21, 2011
    #2

  3. satya Moderator

    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.
    satya, Nov 22, 2011
    #3

Share This Page