Hi All, I always face issues while shrinking the transactional log for a databases on server. All of sudden I notice that log size is 40gb. Shrinking the trasactional log file using DBCC SHRINKFILE doesn't work and there is no drive space to take the DB backup. Can any one sugesst me what is the best possible action need to take for this on the production server? Is it possiblt to shrink or truncate40gb log to 10mb. Please advice on this.