Compression

Hello,

I have been wanting to compress my database. I am not really sure how this is done. I was looking on Enterprise Mangr. and if you right click on the db and go to all tasks, there is an option to shrink database. Is this the way you would compress your database, or are there other ways of doing this?

Thanks for all the help.DUMP

DBCC SHRINKFILE|||Originally posted by Brett Kaiser
DUMP

DBCC SHRINKFILE

How would you do a shrink file?|||Do you have access to Books Online?

Go to the U=Index and look it up

Examples
This example shrinks the size of a file named DataFil1 in the UserDB user database to 7 MB.

USE UserDB
GO
DBCC SHRINKFILE (DataFil1, 7)
GO

Look up DBBC SHRINKDATABASE as well|||Originally posted by Brett Kaiser
Do you have access to Books Online?

Go to the U=Index and look it up

Examples
This example shrinks the size of a file named DataFil1 in the UserDB user database to 7 MB.

USE UserDB
GO
DBCC SHRINKFILE (DataFil1, 7)
GO

Look up DBBC SHRINKDATABASE as well

Thanks again for all your help.|||Shrinkdatabase May not work All the time . Try using Shrinkfiles too.

Also, it is not a good practice to leave Shrink_db option checked ..