I am completely at a loss here and I'm hoping you guys can help me out on this one. I am experiencing the following situation on an SQL Server 2008 R2 database.
MDF-file: Allocated space: 87392.69 MB Available space: 256.13 MB
The LDF file is only a few megabytes, most of which are available. So as you can see my database is pretty full at the moment. I tried looking for the source of this, but here is where things get "weird".
When check the top tables by usage the top table was only 3 GB big, followed by a few of 1 GB. I've summarized all those totals and came to something around +- 20 GB of data. There's a giant gap here... and I'm not sure where it's coming from. I've been googling for the last few hours hoping to get some pointers, I've checked if any BLOB data was causing this but that seems to be not the case as far as I can see.
Am I missing something here? Did anyone experience something like this before? I can't find anything related to this so I'm completely at your mercy.
If you need any specific details I'll add them when requested.
Top 10 tables based on Aaron's query. (masked names for security reasons)
Thanks in advance