MDF file is too big, how to get smaller

waiw123

The number of tables is not large and there is not much data, but there are more than 200M
The ldf file is also relatively small, only 2M
The database MDF of the same size as this database is only 2M.

I tried to shrink the database, but it is now minimal [300M before shrinking]

恶魔右指

Shrink the database file (if it is not compressed, the database file will not be reduced
Enterprise Manager--right click on the database you want to compact--all tasks--shrink the database--shrink the file
Select the data file-select shrink to XMM in the shrink mode, here will give a minimum number of M to allow shrinking, enter this number directly, and confirm it

恶魔右指

Shrink repeatedly until you can't shrink until you can

tyuiopqwer

Shrink it in Enterprise Manager

waiw123

Yes. I have done this already .... There are still 200M.
In theory, it should not be so large: not many tables: 20; not many data: to be precise, there is no data

waxiaoning

Automatic maintenance with a wizard, and then shrink

恶魔右指

Is the log file large?
Enterprise Manager--right click on the database you want to compact--all tasks--shrink the database--shrink the file
Select the log file-choose to shrink to XXM in the shrink mode, here will give a minimum number of M to allow shrinking, enter this number directly, and confirm it

dragonfly_

Export data to create ... insert ... statements
Delete the original database, and then use the exported statements to create database tables and data
That must be small!

yflovefly

1, execute dump transaction database name with no_log in Query Analyzer
2. Shrink the database in Enterprise Manager

waiw123

Did not see improvement. I don't know if it's my improper operation or something else.
I'm as small as 232M now, it seems like it can't be any smaller ...

This database is mainly used to add and delete operations during debugging, I do not know if it has anything to do with this.