<div>
<div class="content wysiwyg-content">
I have no need for these files. so I need an alternative to the &quot;truncate_only&quot; from 2005 to 2008 are there any ideas? &nbsp;Currently in 2005 I use the backup log with truncate_only and then do a dbcc shrinkfile on it. What can I use in 2008 for the same effect? Thanks for any help I recieve.
</div>
</div>


I have no need for these files. so I need an alternative to the "truncate_only" from 2005 to 2008 are there any ideas?  Currently in 2005 I use the backup log with truncate_only and then do a dbcc shrinkfile on it. What can I use in 2008 for the same effect? Thanks for any help I recieve.

Is there a &quot;Truncate_Only&quot; alternative in SQL 2008?

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.

Microsoft SQL Server 2008

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.

Is there a &quot;Truncate_Only&quot; alternative in SQL 2008?

Is there a "Truncate_Only" alternative in SQL 2008?