Post reply

Bulk logged Recovery model

  • March 25, 2009 at 9:04 am

    #219419

    What is Difference between Bulk-logged and Full recovery models? Please explain in terms of transaction log backup

    Thanks in advance

  • March 25, 2009 at 9:27 am

    #966042

    In bulk logged certain operations (I'm not listing the full set, there are a number of complexities) are bulk logged instead of full logged. That means that instead of each record's changes being logged, the only thing logged is the ID of pages that have changed.

    The reduce logging means that the operations will likely be faster and cause less log growth.

    When the log is then backed up, those changed pages have to be included in the log backup. This means that the log backups may be larger than they would be in full recovery.

    There's also implications for point-in-time recovery when using bulk logged.

    I would suggest that you read through the pertinent sections in Books online for all of the details of full recovery and the commands that can be bulk logged and under what conditions they are.

    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

  • March 25, 2009 at 9:32 am

    #966048

    READ book or BOL. it is explained in details there.

    :crazy: :alien:

    Umar Iqbal

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

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