Database size not reduced after compressing tables Using Data Compression, my table size was reduced from 1770 MB to 250 MB, but the database size was not reduced. Why?
You can also shrink a database and shrink database files. See MS:

http://msdn.microsoft.com/en-us/library/ms189035(v=sql.105).aspx

Erik