<div>
You have to backup transaction log - then shink -&gt; files -&gt; choose transaction log file to shrink. <br />

</div>


You have to backup transaction log - then shink -> files -> choose transaction log file to shrink.


<div>
Thanks for the feedback. I forgot to say I have backed it up correctly from with SQL Express before attempting to shrink.<br />
Should I reboot the server after backup or any services before attempting shrink as this has not done much for me so far.<br />
If so I'll need to schedule a restart.
</div>


Thanks for the feedback. I forgot to say I have backed it up correctly from with SQL Express before attempting to shrink.
Should I reboot the server after backup or any services before attempting shrink as this has not done much for me so far.
If so I'll need to schedule a restart.

<div>
<div class="content wysiwyg-content">
sharewebdb has been reduced down to 514Mb through use of the fix me tool.<br />
sharewebdb_log has since grown to be 22GB which is a quarter of the whole drive so I want that space back.<br />
I've connected to the DB using SQL Express, backed it up then shrink the DB, but only reduced by 0.5GB not the savings I hoped for.<br />
Joined Expert Exchange for the solution, fingers crossed you guys can help. <a href="https://filedb.experts-exchange.com/incoming/2011/12_w52/532771/SBS-disk-usage.png" target="_blank" title="SBS Disk Usage (35 KB)"><img alt="SBS Disk Usage" class="file-block lazyload" style="max-width: 756px;" data-src="https://filedb.experts-exchange.com/incoming/2011/12_w52/532771/SBS-disk-usage.png" /></a>
</div>
</div>


SBS-disk-usage.png

sharewebdb has been reduced down to 514Mb through use of the fix me tool.
sharewebdb_log has since grown to be 22GB which is a quarter of the whole drive so I want that space back.
I've connected to the DB using SQL Express, backed it up then shrink the DB, but only reduced by 0.5GB not the savings I hoped for.
Joined Expert Exchange for the solution, fingers crossed you guys can help. 

Sharewebdb_log is 22GB.

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Small Business Server (SBS) is a line of server operating systems targeted at small businesses by bundling the operating system with a number of other Microsoft products that would normally need to be purchased or licensed separately. The most notable inclusions are Exchange, SQL Server, SharePoint and ISA/TMG (Microsoft's firewall and proxy server).