<div>
<b><i>&gt;&gt; Some of that wording doesn't make sense for SQL Server. <br />
</i></b><br />
Agreed. &nbsp;Hence my comment about VM <br />
<br />
But not sure why a backup would offer the option.... Maybe the replication aspect of Veeam ?
</div>


>> Some of that wording doesn't make sense for SQL Server.

Agreed.  Hence my comment about VM

But not sure why a backup would offer the option.... Maybe the replication aspect of Veeam ?

<div>
<div class="content wysiwyg-content">
We are using Veeam to backup our MSSQL servers and there is a setting under application-aware processing that allows us to Truncate the log files. &nbsp;Currently we have both Simple and Full databases (which we backup log files throughout the day). If we were to chose Truncate logs would this only change the logs on the Veeam backup or does it Truncate the files on our MSSQL server first and than backs up the server? Would this cause any issues with our full databases when we are taking log back ups?<br />
Thanks<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279587/1.JPG" target="_blank" title="1.JPG (49 KB)"><img alt="1.JPG" class="file-block lazyload" style="max-width: 452px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279587/1.JPG" /></a><a href="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279588/2.JPG" target="_blank" title="2.JPG (28 KB)"><img alt="2.JPG" class="file-block lazyload" style="max-width: 459px;" data-src="https://filedb.experts-exchange.com/incoming/2018/02_w09/1279588/2.JPG" /></a>
</div>
</div>


1.JPG

2.JPG

We are using Veeam to backup our MSSQL servers and there is a setting under application-aware processing that allows us to Truncate the log files.  Currently we have both Simple and Full databases (which we backup log files throughout the day). If we were to chose Truncate logs would this only change the logs on the Veeam backup or does it Truncate the files on our MSSQL server first and than backs up the server? Would this cause any issues with our full databases when we are taking log back ups?
Thanks




Veeam Transaction Log Settings: Microsoft SQL Server Question

Veeam® has pioneered a new market of Availability for the Always-On Enterprise™ by helping organizations meet recovery time and point objectives (RTPO™) of less than 15 minutes for all applications and data. Veeam develops backup, disaster recovery and virtualization management software for VMware and Hyper-V virtual environments. The company focuses on products that help with virtualized workloads, reduce downtime, and ensure the system Availability required by service-level agreements.

Veeam

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.