<div>
I am glad I could help. &nbsp;Just make sure you are not shrinking the database as a standard practice. &nbsp;If you constantly need to, you may want to look at transaction log backups and settings to ensure you have the correct scheme in place.
</div>


<div>
<div class="content wysiwyg-content">
Hello:<br />
<br />
Is there a utility of some sort that can be used to determine how much space is going to be potentially freed up on a server, prior to running &quot;shrink&quot; on a SQL database?<br />
<br />
TBSupport
</div>
</div>


Hello:

Is there a utility of some sort that can be used to determine how much space is going to be potentially freed up on a server, prior to running "shrink" on a SQL database?

TBSupport

SQL Shrinking &quot;Potential&quot;

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.

SQL Shrinking &quot;Potential&quot;

SQL Shrinking "Potential"