This does not shrink the file size but rather marks portions of the log as 'inactive', which means that SQL Server has recognized that the data has been written to the disk and is no longer needed ...

solution involves creating a T-SQL stored procedure in a SQL Server database called dbo.usp_ShrinkAllLogsExcludeSysDBS that will get a parameter for the database name. The parameter will default to '% ...

In SQL Server 2005 and later, you can create a transaction log backup while a full or differential backup is occurring, but the log backup will not truncate the log due to the fact that the entire ...