Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2013-11-08 : 10:11:03
|
| Hi all,I'm running out of space on my SQL Server box.One of the large databases has 50% unallocated space and 1% unused space in the data file.Can anyone tell me what the difference between unallocated and unused space is?If I shrink the data file, can I get this 50% space back? Or will a shrink only act on the 1% unused space?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-11-08 : 10:54:36
|
| Yes you can get the space back if you shrink the data file. The unallocated space is space you can reclaim, basically free space. Unused space is reserved space that is not yet used. Data that has been deleted but not yet cleaned up by the ghost cleanup process will fall into that bucket.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
unallocated vs unused space