Take the 2-minute tour ×
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 stackoverflow.com 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:

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

Erik

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

Your Answer

 
discard

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