Hi,

I did try

USE MyDatabase

GO

DBCC

SHRINKFILE (MyDatabase_Data, 20000, TRUNCATEONLY)

GO

It did not release much space for me.

   Any other suggestions?

                   Thanks!

Hi,

This is a swing server, I did shrink this database from Enterprise manager. That did not release much space for me. But it shrink the log file. Therefore, I had a...

Thank you very much. I will tell you the results.

Thanks!!! I will try this first.

Thank you very much. I will try that.

Hi,

    Thank you for help. Could you tell me more specific and detail.

                  Thanks!!!