>>Hi,
>>
>>On MSDE database limit is 2Gb. This is for file limit , filegrup limit or sum of size of .mdf and .ndf files in one database?
>>If one file (.mdf) is 2Gb , can i increase the space by creating a second file (.ndf) ?
>
>No. The DB size limit is 2GB (.MDF).

Thanks.

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.