Solved

disk space low for sql server data file only

Posted on 2011-02-11
4
280 Views
Last Modified: 2012-05-11
Expert,

I have one disk hold one data file which is .mdf.  The disk space is low, I shrinked the data file, but it s size didn't shrink to smaller, can you advise what can I do to get more space without add more drive.

Thanks,

Lynn
0
Comment
Question by:yrcdba7
[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
4 Comments
 
LVL 33

Accepted Solution

by:
knightEknight earned 500 total points
ID: 34873064
For a quick fix, create a second data file on another drive.  Initialize it to a substantial size.  Then freeze the file growth on the original file.
0
 
LVL 32

Expert Comment

by:Ephraim Wangoya
ID: 34873087

Just get a bigger capacity disk

Continually shrinking the database does not help

In the meantime you can try and delete temporary files from the disk or uninstall unneccessary applications
0
 

Author Comment

by:yrcdba7
ID: 34873473
there is no temporary files on disk, only one file .mdl file.
0
 

Author Closing Comment

by:yrcdba7
ID: 34890107
Thank you so much, it was big help in that moment.  You are great!

Thanks,

Lynn
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

730 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