Unanswered: Need help!!!! Used Space in dB and Tran files
I have a database about 39GB in size and is running out of allocated space. In the Enterprise Manager the properties for this dB, show that there is 0.00MB space available. I need to increase the size of the dB.
What I need to find out is, which file group is full so I can expand the appropriate file group instead of expanding all the filegroups. Also, is there a way to find the space usage of each file in the file group and also the Transaction log?
db Size 39GB
14 File Groups
17 database files (mdf & ndf)
2 Transaction Log files
I am aware of the sp_spaceused, but the information it furnishes is not enough for me to make a decision.