Solved

SQL Shrinking "Potential"

Posted on 2013-12-18
2
214 Views
Last Modified: 2013-12-18
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
Comment
Question by:TBSupport
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39727448
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
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 39727852
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

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Check ALL SP in database make sure there are no errors 17 71
Are triggers slow? 7 30
query output (script) from a stored procedure 4 54
If in a where clause in t-sql 7 53
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question