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
Solved

SQL Shrinking "Potential"

Posted on 2013-12-18
2
207 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
  • 2
2 Comments
 
LVL 59

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 59

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Server - Sum Decimal Columns 11 43
Is there any way to convert exponential value to number in sql server 5 55
This query failed in sql 2014 5 33
SQL Error - Query 6 40
I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

789 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