Posted by Butaambala on 11/05/05 15:20

Hello,

Using Enterprise Manager, I deleted from my database the only table
that contained records (Right-Click on Table, Choose "Delete Table").
My expectation was that the LARGE .mdf file would be reduced to minimal
size (at least as small as the Northwind MDF). However, it's still 4+
Gig in size!! (Northwind is 2.62 MB). This is a problem, bc I deleted
the table in order to recapture hard drive space.

NOTE: I already tried using Shrink Database in EM. This significantly
reduced the size of the .mdf file from its original (i.e. pre-delete)
size of 38 Gig to present size of 4 Gig.

What can I do to further reduce the size of the MDF file?

Thank you.

[Back to original message]