Post reply

Logshipping Shipping- Regular LOG BACKUP

  • August 28, 2017 at 5:29 am

    #100956

    Hi Experts,

    In our environment we have configured the logshipping for all database, whether it is enough or we can schedule the logbackup hourly to avoid the log growth. Whether it can be done or not?? Is it required??

    Regards
    Narine M

  • August 28, 2017 at 6:27 am

    #1957065

    If you have logshipping setup, do not add anything else to the environment which can do log backups as to do so will affect the LSN's and will break your logshipping.

    You can always schedule the backup job to happen more frequently than the copy and restore job if your worried about log growth.

    Generally you will setup logshipping to meet your companies RPO so you should be comfortable with the backup frequency.

  • August 28, 2017 at 6:59 am

    #1957071

    If you schedule a separate log backup job, you will break log shipping immediately.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 5, 2017 at 2:48 am

    #1958051

    Thank you for the reply.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply