Using SQL Server Management Studio run the following querries.
xp_fixeddrives - best feature ever to see what you dealing with.
SQLPerf (Logspace) will show you how bloated the transaction log
Your results will look something like this
If you have a large file that only has a small percent used then you can shrink it
The database needs to be put in simple recovery model prior to shrinking the files
Right click on the database , Properties, Options, Recovery model : change to Simple
This also commits the transactions to the database
Now you need the file name because you never want to shrink the database only the files.
Right click in the cell, select copy
Paste it in the below script, the number is the MB you want to shrink your file size to.
DBCC SHRINKFILE('your_file_name', 30 )
To see the data file size run EXEC sp_spaceused
To get all the databases file size run
EXEC sp_msforeachdb@command1="use [?] exec sp_spaceused"
If you don’t have any maintenance plans get some