Home Forums SQL Server 2014 Administration - SQL Server 2014 Can we shrink datafile of a database which is configured with log shipping RE: Can we shrink datafile of a database which is configured with log shipping

  • August 22, 2016 at 8:31 pm

    #1896795

    GilaMonster (8/22/2016)

    Jeff Moden (8/22/2016)

    and only back to the last "dirty" VLF for log files.

    Any shrink to the log file only removes space to the last active VLF. VLFs cannot be moved.

    That's what I was saying but...

    Truncate_Only option is ignored when shrinking log files (as it's effectivly the default).

    ... definitely learned something new there. Thanks, Gail.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)