Post reply

VLF & Logfile Shrinking with Logshipping configuration

  • August 23, 2015 at 10:54 pm

    #320757

    Hi,

    We are using Sql server 2012. One of our production database has hight no of vlfs. We are planning to shrink the logfile to reduce the no of VLFs but the database is configured for logshipping.

    What is the effect of logshipping when you shrink the logfile?

  • August 24, 2015 at 1:40 am

    #1821892

    HI

    There will be no impact to the logshipping when you shrink the logfile. The Logshipping will NOT break.

    Thank you.

    Best Regards,

  • August 24, 2015 at 2:49 am

    #1821894

    Just don't set the DB to simple recovery model in the process.

    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

  • August 24, 2015 at 8:40 am

    #1821986

    Is shrinking the log blocks the other transactions? Do it requires downtime?

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

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