Shrink Transaction log file of a database
-- To Find the ldf file names for a database USE DatabaseName SELECT file_id, name, type_desc, physical_name, size, max_size FROM sys.database_files DBCC LOGINFO('DatabaseName') USE DatabaseName; GO ALTER DATABASE DatabaseName SET RECOVERY SIMPLE; GO -- Shrink the truncated log file to 1 MB. DBCC SHRINKFILE (Databaselogical_LogFileName, 1); GO -- Reset the database recovery model. ALTER DATABASE DatabaseName SET RECOVERY FULL; GO --**** Extra Helping Script to get all databases names and their file names and file sizes**** SELECT db.name AS DBName, type_desc AS FileType, Physical_Name AS Location, Mf.name AS logicalFileName, Mf.size FROM sys.master_files mf INNER JOIN sys.databases db ON db.database_id = mf.database_id order by mf.size DESC