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

  • I agree with Gail that this should be posted in a new thread, but based on what you posted it soulds like your database is using the bulk_logged or full recovery model and you have no transaction log backups running against the database. The only way to clear the t-log is to run transaction log backups or switch your database to the simple recovery model.

    Sorry, didn't think a new thread was needed - didn't see the point of creating a new post for the same type of question... but, will definitely do should this occur again.

    Lynn, as an FYI the DB is in FULL mode with TLog backups running every 15 minutes (successfully) - I was just confused that the log_reuse_wait_desc

    still said LOG_BACKUP, even when nothing was running...

    I'll open a new thread

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience