Reduce size of SQL Compact DB?

[dawnlowery]

Is there a script or setting within Lansweeper that I could use to reduce the size of my SQL compact db or maybe certain tables?


Thanks

[Hemoco · Accepted solution]

Try lansweeper\service\databasemaintenance.exe (you need to have version 5.1)

Stop the service
Click on "clear logs" -> Clears all eventlog data
Click on shrink -> makes the file smaller
Start the service