SQL Server How To: Shrink All SQL Server Database Log Files

Run the following command and then copy the results. Comment out any databases you do not want to shrink.

Note this only shrinks the log files of the databases.

set nocount on SELECT ‘USE [‘ + d.name + N’]’ + CHAR(13) + CHAR(10) + ‘DBCC SHRINKFILE (N’’’ + mf.name + N’’’ , 0, TRUNCATEONLY)’ + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10) FROM sys.master_files mf JOIN sys.databases d ON mf.database_id = d.database_id WHERE d.database_id > 4 and mf.type_desc = ‘LOG’


Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store