I was left with a scenario where my Database Initial size is 370GB.
When I checked the
EXEC sp_spaceused, I can see almost 360GB of unallocated space .
Does unallocated space means unused space? If it is unused space, why this is causing the issue for storage?
What options do I have apart from shrinking the .mdf file with 360GB of unallocated space?
Also, as this is a huge database, what level of increments I can mention in the place of 'x' below - can I start from 10,000 MB every time I shrink?
USE Demo GO DBCC SHRINKFILE (N ‘Demo’, x) GO
Is there anything else I should consider in this type of situations?
Would adding a new data file help?