Sign up ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Using Data Compression, my table size was reduced from 1770 MB to 250 MB, but the database size was not reduced. Why?

share|improve this question

migrated from May 19 '13 at 21:14

This question came from our site for professional and enthusiast programmers.

1 Answer 1

up vote 1 down vote accepted

You can also shrink a database and shrink database files. See MS:


share|improve this answer
You should beware when shrinking database files, it affects performance negatively - see… – user5094 May 18 '13 at 12:04
Thanks Erik, it work :) – Hadi Delphi May 18 '13 at 12:08

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.