Home Forums SQL Server 2014 Administration - SQL Server 2014 is bulk logged recovery model support point in time recovery RE: is bulk logged recovery model support point in time recovery

  • December 24, 2014 at 2:46 pm

    #1766380

    Shafat Husain (12/23/2014)

    Hi,

    Point in time recovery is only supported in Full recovery model. So NO, Bulk logged recovery model does not support point in time recovery.

    http://msdn.microsoft.com/en-IN/library/ms189275.aspx

    Hope it helps...!!!

    Ah... you read the following from that article...

    Can recover to the end of any backup. Point-in-time recovery is not supported.

    ... so I don't blame you at all for your answer. The MS-provided article you've cited just isn't 100% correct. Please see Gail's response above.

    I will add that I'd rather normally run in the FULL recovery model and have my procs control whether or not I was going to go to BULK LOGGED and then back to FULL so that I make sure that know exactly when precise Point-in-Time restores might not be available because I'd have to restore the full logfile backup due to a minimally-logged action in the file.

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