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.