Luis Cazares (11/1/2012)
Michael Valentine Jones (11/1/2012)
There is a good chance that all the space is being used by the transaction log. If the database is in full recovery mode and you are not doing regular transaction log backups, the transaction log space used will just continue to grow.Try running this script to see what it tells you:
Script to analyze table space usage
That's a good point, except that he mentioned only the mdf file, not the entire database.
I know, but he might have been mistaken. The script I posted the link for should tell the full story about where the space is being used.