Home Forums SQL Server 2005 Administering Best Index Rebuild/Reorganize and Update Statistics Strategy RE: Best Index Rebuild/Reorganize and Update Statistics Strategy

  • September 26, 2013 at 8:28 pm

    #1653829

    GilaMonster (7/21/2013)

    Jeff Moden (7/21/2013)

    You can simply change back to the FULL recovery mode if in Bulk Logged ....

    You can, but a log backup right before or after the switch is strongly recommended (doesn't really matter the order)

    http://www.sqlservercentral.com/articles/Recovery+Model/89664/

    Just remember that even in the Bulk Logged mode, a Point-In-Time restore can't be done for any log file where you were in the Bulk Logged mode. You can only use the whole logfile backup or not during those time frames.

    A point in time restore can be done while in bulk-logged recovery, unless that log backup contains a minimally logged operation. Only log backups that contain minimally logged operations must be restored in full. If a log backup contains no minimally logged operations, then you can restore to any point within that, just as in full recovery.

    Apologies for the late response. Thanks for the clarification on the ability to do PIT restores while in the bulk-logged mode if there are no minimally logged operations.

    --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)