Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

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
0
TBSupport
Asked:
TBSupport
  • 2
1 Solution
 
Kevin CrossChief 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

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now