What does shrinking SQL log file do?

Should I shrink SQL log file?

To reduce the physical size of a physical log file, you must shrink the log file. This is useful when you know that a transaction log file contains unused space.

Is it safe to shrink transaction log in SQL Server?

My file "Transaction log" is so big. First i changed my database recovery model to 'Simple' and than i used Task>Shrink>File. On this new opened widnow (Shrink File), i see my 'available free space' is around 10 GB (minimal less then 10GB). ... Question.AleksanderKepJoined Oct 20172AleksanderKep's threads Show activity

What does shrinking a SQL database do?

The Shrink Database task reduces the size of SQL Server database data and log files. By using the Shrink Database task, a package can shrink files for a single database or multiple databases.

Does SQL log file affect performance?

If the transaction log file is full in the SQL Server database, it degrades the performance of the SQL Server. It also slows down the speed of the transactional log backup process. In addition, the over-sized transaction logs decrease the disk space also because old transaction logs are not removed yet.