Loading...
Loading...
After Veeam Backup & Replication or Veeam Agent for Microsoft Windows successfully truncates a SQL Server Database with Application-Aware Processing enabled, the SQL Log File (.ldf) does not become smaller.
This is due to the fact that the LDF file itself is a container, when truncation occurs the internals of the LDF are cleared and space is freed within it, but the LDF itself is not made smaller. One could manually shrink or configure “Auto Shrink” to make the LDF itself physically smaller.
Considerations regarding Shrinking The information provided below is a limited explanation of shrinking and is only intended to demonstrate how to perform a shrink operation. Veeam Support highly recommends before shrinking, you review options with your SQL Administrator and conduct independent research. Many tech articles recommend against shrinking when it is not strictly necessary. Before performing a shrink operation, you should fully understand the impacts of shrinking (e.g. fragmentation and performance). Advised reading regarding SQL shrinking can be found here: https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-file
Click on a version to see all relevant bugs
Veeam Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.