Home Forums SQL Server 2008 T-SQL (SS2K8) How to manage Transaction Log. RE: How to manage Transaction Log.

  • July 31, 2012 at 2:24 pm

    #1519968

    GilaMonster (7/31/2012)

    sestell1 (7/31/2012)

    Setting the database to SIMPLE recovery model will minimize the amount of logging done

    Won't help here. Updates are fully logged in all recovery models. A single update uses the same amount of log space in simple or full recovery

    Sorry, I thought there were multiple updates being done.

    If a single update is blowing out your transaction log, then yea your only option is to break the update into batches of records.