Post reply

difference bw full & Bulk logged recovery models

  • October 26, 2005 at 4:52 am

    #188230

    hi

    want to know what is the difference b/w full & bulk logged recovery models.

     

  • October 26, 2005 at 7:01 am

    #600111

    Full logs EVERYTHING as it happens.

    Bulk-logged reduced logging for some operations such as bcp, CREATE INDEX, SELECT INTO (see BOL for full list) as theyhappen. Bulk operations are then fully recorded at the next T-log backup.

    This means you can do "point in time" restores in Full because all restore info is available in order etc.

    In Bulklogged where you restore only to the last T-log backup (to redo the bulk operation)

    HTH, Shawn

     

  • October 27, 2005 at 12:26 am

    #600471

    hi Shawn,

    thanks for ur reply.I was a bit confused as I thought bcp was a non logged operation & hence it will not be writtern in log file irrespective of recovery model(just like truncate).

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

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