<div>
From SSMS run Task -&gt; Shrink -&gt; Files and shrink the Log file.<br />
Mark the option &quot;Reorganize pages Before releasing unused space&quot; and set &quot;Shrink file to&quot;.<br />
<br />
Make sure that the Log file is not shrink to 0% available space after shrink. <br />
This file size is depending on the amount of transactions made to the database.<br />
<br />
Then setup a backup job with option FULL to make a backup of the database. If the Recovery Model is set to FULL on the database also make a log backup between the FULL backups.<br />
Typically a log backup is set to every hour during the day when the transactions is made to the database. This will help to have the transaction log in shape.
</div>


From SSMS run Task -> Shrink -> Files and shrink the Log file.
Mark the option "Reorganize pages Before releasing unused space" and set "Shrink file to".

Make sure that the Log file is not shrink to 0% available space after shrink.
This file size is depending on the amount of transactions made to the database.

Then setup a backup job with option FULL to make a backup of the database. If the Recovery Model is set to FULL on the database also make a log backup between the FULL backups.
Typically a log backup is set to every hour during the day when the transactions is made to the database. This will help to have the transaction log in shape.

<div>
I cannot find this option :<br />
&nbsp;&quot;Reorganize pages Before releasing unused space&quot;
</div>


I cannot find this option :
 "Reorganize pages Before releasing unused space"

pic.PNG

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have some SQL logfiles which are very big. over 80GB.<br />
With a command I checked the log and just 1% is used.<br />
Under options of this DB I found the feature autoshrink file.<br />
<br />
When I use autoshrink, is this a problem ?<br />
Or do I have some disadvantages ?
</div>
</div>


Hi Experts,

I have some SQL logfiles which are very big. over 80GB.
With a command I checked the log and just 1% is used.
Under options of this DB I found the feature autoshrink file.

When I use autoshrink, is this a problem ?
Or do I have some disadvantages ?

SQL Logfiles over 80GB

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.