Home Forums SQL Server 2008 SQL Server 2008 Administration transaction log size reduction RE: transaction log size reduction

  • March 28, 2013 at 1:50 pm

    #1601835

    MyDoggieJessie (3/28/2013)

    If you haven't specified it during the initial install, it's set to 0 by default, meaning that it happens automatically (running approximately every 1 minutes for active DB's)

    Reference MSDN here

    Thanks, that is what I found, it is 0.

    So the checkpoints commits approximately every one minute, that is quite frequent than I think.