SQL Server: reduce the size of the transaction log

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 …

Read more