Optimization

SQL Server: reduce the size of the transaction log

   -     -     -   (0)  -    1 minute

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


Veeam: Resolving the Volume Problem of Backups on Deduplicated Servers

   -     -     -   (0)  -    1 minute

Symptom On Windows servers with deduplication enabled, at regular intervals the backup size is increased. Below are several screenshots showing the problem: Reason The problem is not with Veeam software, but with deduplication on Windows Server. When configuring deduplication, a memory cleanup job is configured to optimize deduplication, by default this is done every Saturday …

Read more