<div>
You could also truncate the log files (but need to follow by full backup)<br />
dump tran &lt;DBNAME&gt; with no_log<br />

</div>


You could also truncate the log files (but need to follow by full backup)
dump tran <DBNAME> with no_log


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I just deleted 3 unneeded indexes from a very large table (30GB.) &nbsp;The operation appeared to take effect immediately. &nbsp;I am now noticing that the log file backups which are taken every 15 minutes are about 800MB each (they're normally about 2mb each.)<br />
<br />
Is this normal? &nbsp;Is this being caused by autoshrink running silently in the background? &nbsp;I Google but couldn't find a way of determining if autoshrink was in the middle of an operation. &nbsp; <br />
<br />
I'm hoping it stops before it fills my backup drive completely!
</div>
</div>


Hi

I just deleted 3 unneeded indexes from a very large table (30GB.)  The operation appeared to take effect immediately.  I am now noticing that the log file backups which are taken every 15 minutes are about 800MB each (they're normally about 2mb each.)

Is this normal?  Is this being caused by autoshrink running silently in the background?  I Google but couldn't find a way of determining if autoshrink was in the middle of an operation.   

I'm hoping it stops before it fills my backup drive completely!

Autoshrink and log file growing in SQL 2005

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.