SQL Server: reduce the size of the transaction log

Originally published at: SQL Server: reduce the size of the transaction log - RDR-IT

In this « troubleshooting » tutorial, we will see how to reduce the transaction file (ldf) of a SQL Server database. Normally this file is truncated during server backups (Veeam, Altaro …) or by the maintenance plan. In certain situations with SQL Express, the « truncation » is not done and if the size of the file is badly…