Posted onNovember 3, 2010 by Josephine shrinking transaction log to find the log name – select name from sys.database_files where type = 1 to shrink to a specified target size – DBCC SHRINKFILE (DataFile1, 7); –where 7 = 7MB