MSDE database

altså gøre MSDE databasen mindre

http://sqlserver2000.databases.aspfaq.com/how-do-i-reclaim-space-in-sql-server.html

should also apply to MDSE

Maybe consider moveing to SQL Express which I think has a 4GB limit

The links on the page arent working
In the near future we will move to SQL EX but for now i need this to work out :)

dump data til et eller andet format
slet data i databsen
saa er pladsen klar til genbrug

(at shrinke database file og lade den udvide sig igen er kun en maade at oedelaegge performance paa)

You can google
DBCC SHRINKDATABASE etc. and you should find info.

http://msdn.microsoft.com/en-us/library/ms190488.aspx

And as far as I know the 2Gb limit is on each dB so you can create a new dB and make a backup of data to that then delete rows you dont need. But if you need the data then you obvioulsy cant do that.