SQL Shrinking "Potential"

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
LVL 1
TBSupportAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Hi.

You may want to look at sp_spaceused (http://technet.microsoft.com/en-us/library/ms188776.aspx). You can also use the GUI for Shring > Database|Files, which will show you the free space.
0
 
Kevin CrossChief Technology OfficerCommented:
I am glad I could help.  Just make sure you are not shrinking the database as a standard practice.  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.
0
All Courses

From novice to tech pro — start learning today.