If you have Enterprise Manager installed right click your database and select all tasks and then click shrink database.
HTH,
Enmanuel
>Hi,
>
>Is there a problem with MSDE in terms of space allocation? I have 2 databases on MSDE and somenthig is wrong :
>
>database A has average double more records than B and size is 1067MB
>database B has 2022MB and identical structure with A
>
>in database B there are more trafic than A - insert, updates, deletes
>
>What to do to shrink database at normal size?
>
>Thanks in advance.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain