I have a drive, :d
, in my server where I have my .mdf file stored and now all of a sudden I notice that the drive :d
has no space left.
When I checked the .mdf file of the database demo1
, it is 1.6TB and occupies the entire drive :d
. That is an important database and I cannot truncate tables in there.
I checked the database properties and noticed that the initial size of the .mdf is given as 1.6TB by the person who created the database.
How can I reduce the .mdf file size now? I tried shrinking, but it didn't help.
Any idea is helpful.
DBCC SHRINKFILE
will reduce the size of an MDF, if there's free space available to release. What exactly was the outcome? Is there free space in the file? If not, you'll need to delete records, drop indices, compact tables, etc. Is that the part with which you need help? – Jon of All Trades Jun 10 '19 at 16:58