Author: chumble | Posted on: 2/3/2009 11:35:35 AM | Views : 510

I've posted this question in another forum here so forgive the cross posting.

I have found myself with an ASPNETDB.MDF file of over 250MB in size.

It contains many tens on thousands of users and their profile information.  I no longer need some of this profile information and I no longer require the anonymous users.

I've attempted ProfileManager.DeleteInactiveProfiles(....)  and this leaves the size of the file intact.

I've written my own C# to go through all users and delete out the unwanted Profile entries.

I cannot seem to bring the file sizes down (if I get a reduction in the MDF file I get an equivalent increase in the LDF file despite changing its Recovery mode to Simple).

Any clues??

Many thanks

Clive.
...

Go to the complete details ...