<div>
Assuming the database is in FULL recover mode, FULL and T-log backups are taking regularly and the command below<br />
<br />
DBCC SQLPERF(LOGSPACE);<br />
<br />
shows indeed &quot;free&quot; space inside that database T-log you could add a step to the SQL Job that the Maintenance Plan creates to execute the TSQL SHRINK command.<br />
Just caution that any time you modify/save the Maintenance Plan the SQL Job will be recreated so the step you manually added will be lost and you need to add it back in.
</div>


<div>
I did see the Shrink command as a step in the wizard. So I shouldn't have to use a tsql command but my question is shouldn't a normal full transaction log backup through the wizard truncate the logs?
</div>


<div>
Truncate the log is different that SHRINKFILE - truncate will just release used space in the T-log after the log backup and SHRINKFILE will physically reduce the size of the T-log(s) files on the disk and...are you sure you need to SHRINKFILE ?<br />
<br />
Usually T-log backup does the truncate and you will see the &quot;free&quot; space in the T-log by running <br />
DBCC SQLPERF(LOGSPACE);<br />
<br />
here's how TRUNCATE LOG works:<br />
<a href="https://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx" rel="ugc">https://technet.microsoft.com/en-us/library/ms189085(v=sql.105).aspx</a>
</div>


<div>
<div class="content wysiwyg-content">
EE,<br />
<br />
I'm running SQL 2012 and having an issue truncating the transaction logs through the maintenance plan. I don't see an option to truncate. Additionally, I did a manual shrink of the _log file for the LDF database but it remained the same size. I even switched to simple recovery model but still had to run a T-SQL command manually as shown below.<br />
<br />
Ultimately want this to happen automatically since I need FULL recovery mode for Mirroring purposes<br />
<br />
DBCC SHRINKFILE (ACCESS_log,300)<br />
<br />
Is there an easier way?<br />
<br />
Thanks
</div>
</div>


EE,

I'm running SQL 2012 and having an issue truncating the transaction logs through the maintenance plan. I don't see an option to truncate. Additionally, I did a manual shrink of the _log file for the LDF database but it remained the same size. I even switched to simple recovery model but still had to run a T-SQL command manually as shown below.

Ultimately want this to happen automatically since I need FULL recovery mode for Mirroring purposes

DBCC SHRINKFILE (ACCESS_log,300)

Is there an easier way?

Thanks

SQL Trans Backups

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.