SupportSQL

Use this batch to quickly shrink all database log files, freeing up any space at the end of the file. To shrink even more, first complete a full database backup, then run this:

DECLARE @cmd nvarchar(max)

SET @cmd = ‘use [?]; DBCC SHRINKFILE (2, TRUNCATEONLY);’

EXEC sys.sp_MSforeachdb @command1 = @cmd