<div>
I agree with Angel. &nbsp;Thought you indicated you were running the transaction log backup every 15 minutes...which is why I thought it should work as you have it.<br />
<br />
Maybe try increasing the time to 1HR as that is what I am using as well and have had no problems with it not truncating.
</div>


I agree with Angel.  Thought you indicated you were running the transaction log backup every 15 minutes...which is why I thought it should work as you have it.

Maybe try increasing the time to 1HR as that is what I am using as well and have had no problems with it not truncating.

<div>
<div class="content wysiwyg-content">
I am doing FULL backups at 12:00 AM every night with the below script. &nbsp;From 6:00 AM until 10:59:59 PM everyday I am running the lower most script every fifteen minutes. &nbsp;Problems is that the database .ldf is growing and growing. &nbsp;How do I trim it down prior/or during the Full backup?<br />
<br />
BACKUP DATABASE [AdminDB] TO &nbsp;DISK = N'\\clwfile03\system_backu<wbr />ps$\CLWSQL<wbr />PD01\Admin<wbr />DB_FULL.Ba<wbr />k' WITH NOFORMAT, INIT, &nbsp;NAME = N'AdminDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, &nbsp;STATS = 10<br />
GO<br />
<br />
BACKUP LOG [AdminDB] TO DISK = N'\\clwfile03\system_backu<wbr />ps$\CLWSQL<wbr />PD01\Admin<wbr />DB_Log.Trn<wbr />' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, <br />
NAME = N'Pods-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10<br />
GO<br />

</div>
</div>


I am doing FULL backups at 12:00 AM every night with the below script.  From 6:00 AM until 10:59:59 PM everyday I am running the lower most script every fifteen minutes.  Problems is that the database .ldf is growing and growing.  How do I trim it down prior/or during the Full backup?

BACKUP DATABASE [AdminDB] TO  DISK = N'\\clwfile03\system_backups$\CLWSQLPD01\AdminDB_FULL.Bak' WITH NOFORMAT, INIT,  NAME = N'AdminDB-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

BACKUP LOG [AdminDB] TO DISK = N'\\clwfile03\system_backups$\CLWSQLPD01\AdminDB_Log.Trn' WITH RETAINDAYS = 1, NOFORMAT, NOINIT, 
NAME = N'Pods-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO


Trim ldf

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.