Home Forums SQL Server 2005 Backups log backups not clearing transaction log - no open transactions found RE: log backups not clearing transaction log - no open transactions found

  • February 26, 2011 at 9:14 am

    #1291918

    I'v been doing some checking.

    No mirroring or replication going on.

    I do have 1400 VLF's

    The reason I want it small is that I am reindexing some large tables and am taking a log backup after each one which typically clears it out. The last one did not clear it out.