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've got a log reuse type of LOG_BACKUP, but there's no transaction log backup running. I've run a maintenance job to see if that would clear out my LDF file but nothing's changing. It's still full...

    Server: Microsoft SQL Server 2005 - 9.00.5057.00 (Intel X86) Mar 25 2011 13:50:04 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

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